Skip to content

Instantly share code, notes, and snippets.

@mullnerz

mullnerz/create and restore mysql db

Created January 12, 2015 08:33
Show Gist options
  • Save mullnerz/466381137fc16a806bd3 to your computer and use it in GitHub Desktop.
Save mullnerz/466381137fc16a806bd3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create and restore mysql db
create database if not exists `${DB_NAME}`;
grant all privileges on `${DB_NAME}`.* TO `${DB_USERNAME}`@`localhost` identified by '123';
grant all privileges on `${DB_NAME}`.* TO `${DB_USERNAME}`@`%` identified by '123';
mysql --force --user ${DB_USERNAME} --password ${DB_PASSWORD} ${DB_NAME} < ${DB_NAME}.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment