MySQL recipe #1

[elfs]

I’m putting this here because I’m tired of losing it.  I hate having to look up every time the exact same recipe for “how do I create a new empty database for Django or Rails in MySQL?’  It’s in two different sections of the O’Reilly MySQL in a Nutshell book, and while I have both bookdarted and know where to find them, it’s nice to have them in just one place!  The  phrase ‘to X’ on line 4 is the database username, and the ‘identified by’ string there is your database password, in case you were wondering.

# mysql -u admin -p
password:
mysql> create database secretproject;
mysql> grant all on secretproject.* to secretproject identified by 'redacted';
mysql> flush privileges;
mysql> quit;
#

This entry was automatically cross-posted from Elf's technical journal, ElfSternberg.com

Comments

[duskwuff.livejournal.com]

The fact that it always says "0 rows updated" always puzzled me.

Probably because every statement that hits the server has to either return a count of result rows (SELECT, DESCRIBE, SHOW, etc) or a count of modified rows (UPDATE, DELETE, etc). Since FLUSH PRIVILEGES doesn't actually touch any rows, the 0 count is arbitrary.