Creating your MySQL Database

You can create three dabases and you them as your development, test and production databases. they do not have to be on differnt servers.


CREATE DATABASE myprojectdb_dev CHARACTER SET utf8;;
CREATE DATABASE myprojectdb_test CHARACTER SET utf8;;
CREATE DATABASE myprojectdb_prod CHARACTER SET utf8;;

GRANT ALL ON myprojectdb_dev.* TO 'myprojectdb'@'%' IDENTIFIED BY 'myprojectdb';
GRANT ALL ON myprojectdb_test.* TO 'myprojectdb'@'%' IDENTIFIED BY 'myprojectdb';
GRANT ALL ON myprojectdb_prod.* TO 'myprojectdb'@'%' IDENTIFIED BY 'myprojectdb';

FLUSH PRIVILEGES;