[Newbie] MySQL & users

[Valechumbar]

Another VPS question (Hope all this doubts help other users too)

The only way I find to use MySQL databases (created in Plesk) is to create a user for every single database I use.

Is there a way to assign a user to more than one db? So I don't have to create an remember different users to each db

Thanks in advance...

[cef]

I've never used Plesk so I don't know what it's created inside of MySQL, but you can use the mysql GRANT function to change access rights to databases.

Log in to mysql as root or admin or someone with "full" privileges, and execute this command:

GRANT ALL ON db_name.* TO user_name

(of course you will need to use real information for db_name and user_name)

This will give the user "user_name" full read/write access to the database named "db_name".

For reference, here's the GRANT syntax page in the mysql docs:

http://dev.mysql.com/doc/refman/4.1/en/grant.html

Hope this helps.