MySQL table privileges (limiting access to just a table)

[dico]

Hello,

I need so help with mysql. I need to have it so that a mysql user has access to only one table in a DB. I've added users before that have access to the whole DB, but I've not limited that to a certain table.

I am using phpMyAdmin.

I've already added the user in the 'users' table and added the user in the 'db' table (with everything set to NO) and now i assume i have to add the user to the 'tables_priv' table. Since i've never done this before I don't know what i put in the 'grantor' field nor the 'timestamp' field. Also, can i select multiple choices from the tables_priv and columns_priv select boxes?

Thanks,

-dr

[bastien]

use the sql grant statement to manage it...I have never liked PMAs user interface