Creating mysql development database

Quick & dirty way to create a localhost db for testing. Database is called db_dev and user is called db_dev_user

mysql -u root -p



mysql>CREATE SCHEMA db_dev;

Query OK, 1 row affected (0.01 sec)



mysql>CREATE USER 'db_dev_user'@'localhost' IDENTIFIED BY 'Passw0rd';

Query OK, 0 rows affected (0.01 sec)



mysql>GRANT ALL PRIVILEGES ON db_dev.* to 'db_dev_user'@'localhost';

Query OK, 0 rows affected (0.01 sec)



mysql>FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.01 sec)



mysql>QUIT;

Bye