[thelist] mySQL question

[Tom Dell'Aringa]

Hi,

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?

Thanks

Tom


http://www.pixelmech.com/

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...