MYSQL - Granting Permissions priviliges to Specific Tables

[hdogg]

Hi-

I have a database with say... 10 tables. And mutiple users....

I would like to restrict access for one of the users to only be able to access table 1 with full and none of the others... how do i do that?

[chazzy]

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

Look where it says "table level"

[hdogg]

so would i essentially create a user with 0 permissions aka revoke them all... and then do the grant by table?

do i have to use shell? or could i run the commands through php myadmin?

[chazzy]

you should only need to revoke if they already have the wrong permissions.

you should be able to run it via PHPMyAdmin