[thelist] mySQL question

Tom Dell'Aringa pixelmech at yahoo.com
Fri Oct 7 13:12:30 CDT 2005


I'm working through the book Agile Web Development with Rails. In setting up the mySQL DB they
have these commands for the 3 databases:

grant all on depot_development.* to 'dave'@'localhost';
grant all on depot_test.* to 'dave'@'localhost';
grant all on depot_production.* to 'prod'@'localhost' identified by 'wibble';

I understand that grant is giving permission to the user dave to that particular db (I think).
What I don't get is the 'identified' part or why the grantee is prod instead of dave on the
production db.

Any insights?




A man spoke frantically into the phone: "My wife is pregnant and her contractions are only two minutes apart"! "Is this her first child?" the doctor asked. "No, you idiot!" the man shouted. "This is her husband!"

Q: What do you call a muddy chicken who crossed the road two times?
A: A dirty double crosser...

More information about the thelist mailing list