Setting privilages for mysql users

[ShaolinF]

Hi Guys

I have 3 users on my mysql server with full privilages. The problem is if I log in with any one of these accounts I am able to see ALL tables regardless of who made them. Is there any way I can change this so that users can only see the tables they have created ?

[Coreigh]

I am not a MySQL expert but I believe it is something like this:


deny all privileges on somedb.tablename to 'someuser' identified by 'passwrd';


I usually use a GUI like phpmyadmin, somehow I think I understand what I'm doing better if I can see it.

The mysql website has pretty good documentation, you can probably find a specific answer there with some reading.

[Iowan]

No expert here either, but a user with GRANT privileges can GRANT or REVOKE privileges to SHOW, SELECT... to name a couple. I can't say the HELP command has provided me with much information. Privileges can be limited to databases, tables, or (maybe) fields.