add a user to a mysql DATABASE.

[duckxtales]

Hi,

what is the mysql command to create a user and add it to an exsisting database?

thx

[mcibor]

I use:

GRANT SELECT, INSERT, UPDATE, DELETE ON database.* TO 'user'@'localhost' IDENTIFIED BY 'password'

or GRANT ALL
or ON database.table

Hope this helps

More here
[dev.mysql.com...]