Setting MySQL permissions for a Rails project

Enter mysql as root:

• mysql -u root -p

Grant permissions for each dev, test, & prod databases:

• GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON rails_project_development.* TO 'username'@'localhost' IDENTIFIED BY 'password';
• GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON rails_project_test.* TO 'username'@'localhost' IDENTIFIED BY 'password';
• GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON rails_project_production.* TO 'username'@'localhost' IDENTIFIED BY 'password';