I ALWAYS forget how to create new mysql databases... it's horrible. I do this so infrequently which means I also have to google everytime it comes up.
1 2 3 4 5
-- First create the database
create database new_database;
-- Then give all privs to the correct user
grant select, insert, update, delete, create, drop, references, index, alter,
(
Read more... )