[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