MySQL - Table Level Permissions

[cancer10]

Hi

I have a MySQL 5.x database. I have 5 tables in it. Is there anyway I can have 5 users assigned to 5 different tables in such a way that one user can have access to the DB but can ONLY view his own table and not view any other tables in that DB?


Pls suggest.


Thanks

[themarty]

This is explained here:

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

When you've opened that page, just do a search for 'table privileges'

[cancer10]

The example shown on that site is too confusing LOL

Can u pls give me a simple and easy to understand syntax? I am a beginner.


Thanks

[themarty]

they put an example of the syntax right below the 'table privileges' heading ... i cannot put it more simple than that....

if there's something you don't understand you'll have to be more specific about what it is you don't understand