snippetsmania.com

MySQL create databases script

CREATE DATABASE mydb_development;
CREATE DATABASE mydb_test;
CREATE DATABASE mydb_production;
GRANT all ON mydb_development.* TO 'my_username'@'localhost';
GRANT all ON mydb_test.* TO 'my_username'@'localhost';
GRANT all ON mydb_production.* TO 'my_username'@'localhost' identified BY 'my_password';

Make a SQL script that creates 3 databases and assigns all rights to my_username.

Tags