Tuesday, July 2, 2013

Stupid Mysql

I really really don't like Mysql but it seems like a necessary evil sometimes.  There are so many bugs and edge cases but so many people us it that its hard to get away from it.  I can never remember the syntax for creating users and giving them access to db's so I'm going to just leave this here for myself...

CREATE DATABASE database_name;
CREATE USER 'who'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON database_name.* TO 'who'@'localhost';

Now this is really basic stuff and I realize it, but the point is that I hate looking it up. The sad thing is that after writing this blog post I'll probably never forget it.

No comments:

Post a Comment