[KLUG Members] mysql

[bill]

On Mon, 2004-09-06 at 11:23, komal wrote:
> Hi
> I am facing problem in MySQL database administration on user rights. I want
> to restrict user from accessing MySQL database. 

Just restricting one user?

> For this I issued revoke all
> on MySQL.* from komal at localhost;
> 
> MySQL gave me error that there is no grants define for user komal in host
> tables;

Well, is there a user komal?  You can't remove rights from a user that
doesn't exist.

You also need GRANT privileges to be able to run REVOKE.