[thelist] mySQL question
M. Seyon
evoltlist at delime.com
Fri Oct 7 13:51:14 CDT 2005
Message from Tom Dell'Aringa (10/7/2005 11:12 AM)
>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.
'identify by' is the password.
http://dev.mysql.com/doc/mysql/en/adding-users.html
And maybe they just want to have a different user on the prod server than
on the dev/test
servers?
regards.
-marc
More information about the thelist
mailing list