On Mon, 06 Sep 2004 20:53:42 +0530, komal agencies_ad1@sancharnet.in wrote:

Hi I am facing problem in MySQL database administration on user rights. I want to restrict user from accessing MySQL database. For this I issued revoke all on MySQL.* from komal@localhost; MySQL gave me error that there is no grants define for user komal in host tables; What does it mean?

The error says it all. You have not GRANTed any rights to the user komal on the mysql database which stores the permissions on various databases and tables. Hnce they cannot be revoked. To see all the user who have been given privileges to certain portion of the database. do the following.

mysql> use mysql; mysql> select * from user;

you will mave to do the baove logged in root.

On Mon, Sep 06, 2004 at 08:53:42PM +0530, komal wrote:

I am facing problem in MySQL database administration on user rights. I want to restrict user from accessing MySQL database. For this I issued revoke all on MySQL.* from komal@localhost;

MySQL gave me error that there is no grants define for user komal in host tables;

What does it mean?

Read sections 5.4 and 5.5 from the MySQL manual, that describe the MySQL privilege concepts and user management.

Sameer.