[thelist] mySQL question

[Jay Blanchard]

[snip]
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.
[/snip]

grant all on depot_development to dave without a password
same to dave on depot test
grant all on depot_production to prod with password wibble

you could

grant all on depot_production.* to 'dave'@'localhost' identified by
'wobble';

now you have two users on depot_production, each with his own password