How to make a constraint on a user?

[HoMyGod]

Hello,

I have several databases on a machine. I would like to configure mysql so that a user called "user1" can access only one database "user1_database". I know that we must play with the tables user and db of the mysql database, but it doesnt'work. Do I need to do something else?

Thank you very much,
H.

 

[rycamor]

Learn how to use the GRANT and REVOKE syntax:

http://www.mysql.com/doc/G/R/GRANT.html

and

http://www.mysql.com/doc/A/d/Adding_users.html