How to: create a MySQL database and user

March 26th, 2009 by David Janes

I always seem to forget this:

$ mysql -u root -p

Enter password: enter mysql-root-user passwd

mysql> CREATE DATABASE DATABASENAME

mysql> GRANT ALL PRIVILEGES ON DBNAME.* to "DBUSER"@"localhost" IDENTIFIED BY "DBPASSWORD";

mysql> FLUSH PRIVILEGES;

mysql> EXIT