Deny mysql user to a database?

[JamesCliff]

Hi all,

Ok, i want to deny a certain user access to a certain database on my server. How do i do this?

And then i want to assign a certain user all access to a certain database as well, so that the user cannot even select data from other databases, just the database its assigned to. So its like the other databases on my server dont exist to this certain user im assigning to a certain database if you understand me.

I already have assigned a user fred to the database plant.
I have also already assigned a user jon to two databases flower and seed. However the user jon can still select data in the database plant.

Where am i going wrong and howdo i accompish the task im trying to do?

Thanks

Jim

 

[LTeeple]

See

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

MySQL manual on GRANT/REVOKE syntax. That should help you get started.


Cheers!
Laura