Return to Snippet

Revision: 914
at December 27, 2007 00:05 by yuconner


Updated Code
mysql> CREATE DATABASE ''databasename''; 

mysql> GRANT ALL PRIVILEGES ON ''databasename''.* TO "''username''"@"''hostname''" IDENTIFIED BY "''password''";

mysql> FLUSH PRIVILEGES;

mysql> EXIT

Revision: 913
at August 21, 2006 01:09 by yuconner


Initial Code
mysql> CREATE DATABASE ''databasename''; 

mysql> GRANT ALL PRIVILEGES ON ''databasename''.* TO "''username''"@"''hostname''" -> IDENTIFIED BY "''password''";

mysql> FLUSH PRIVILEGES;

mysql> EXIT

Initial URL


Initial Description
$ mysql -u ''adminusername'' -p

Initial Title
Command line instructions to create a database in MySQL

Initial Tags
database

Initial Language
SQL