Skip to content

Instantly share code, notes, and snippets.

@hoangitk

hoangitk/create new database.mysql

Last active August 29, 2015 14:05
Show Gist options
  • Save hoangitk/e5d302dca5c750f42cac to your computer and use it in GitHub Desktop.
Save hoangitk/e5d302dca5c750f42cac to your computer and use it in GitHub Desktop.
Download ZIP
MySql: Create new database
Raw
create new database.mysql
mysql> CREATE DATABASE newdbname CHARACTER SET utf8;
mysql> CREATE USER 'newdbuser'@'localhost' IDENTIFIED BY 'my_password';
mysql> GRANT ALL PRIVILEGES ON newdbname.* TO 'newdbuser'@'localhost';
mysql> \q
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment