How do I grant usage to a table in

[buzzt]

How do I grant usage to a table in my database to a someone from a specific IP address? What about just anybody from anywhere?

Also, how do I get rid of the user once I am done with him. I mean, I can REVOKE his rights, but how (where) do I delete him?

 

[sleipnir214]

The syntax for the GRANT and DELETE statement can be found here:

http://www.mysql.com/doc/en/GRANT.html

To grant permission on a specific database and table to a specific username and IP is something like:

GRANT SELECT ON databasename.columnname TO 'username'@'1.2.3.4' IDENTIFIED BY 'password'

Make sure to read on the use of wildcards in the host part of the username.

Once you have REVOKEd permissions, the user's record can be deleted from the tables "user" and "db" in the "mysql" database. Tinker with these tables with extreme caution. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!