Deny access to my DB

[mrdance]

I want to share my mySQL with other users but deny accesses for my own databases. I thought that I could use this line to deny access to the database test but it didn't work.

INSERT INTO db
(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv)
VALUES
('localhost','test','testuser','N','N','N','N','N','N');

Any suggestions?

 

[rycamor]

Fine-grained user permissions is one of the better features of MySQL.

Rather than inserting records directly into the mysql database, try using the built-in GRANT and REVOKE syntax, which will let you know more directly whether you are accomplishing your goals or not.

See

http://www.mysql.com/doc/G/R/GRANT.html.

The instructions are nice and clear, and the examples are as obvious as it gets.