Skip to content

Instantly share code, notes, and snippets.

@aoberoi

aoberoi/create_user_and_db.sql

Last active August 29, 2015 14:10
Show Gist options
  • Save aoberoi/90609e9656598c2f5d85 to your computer and use it in GitHub Desktop.
Save aoberoi/90609e9656598c2f5d85 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL User Creation with Databse
Raw
create_user_and_db.sql
# See: http://stackoverflow.com/a/1720254
CREATE USER 'user1'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE db_database1;
GRANT ALL PRIVILEGES ON db_database1.* To 'user1'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment