From: Mysql mail list Date: April 5 1999 4:40pm Subject: Re: privileges List-Archive: http://lists.mysql.com/mysql/1424 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Mon, 5 Apr 1999, Michael Widenius wrote: > REVOKE ALL PRIVILEGES ON database.* from nobody@localhost WITH GRANT OPTION > > This will leave the user 'nobody' with the the password 'something' in > the user table, but without any privileges. > > If you also want to remove this, you have to do: > > delete from mysql.user where user='nobody' and host='localhost'; > flush privileges; > > Regards, > Monty > thanx for information, it seems to work ... Eugen