2 messages in com.mysql.lists.win32Re: Newbie Question
FromSent OnAttachments
Friedhelm Betz07 Nov 2002 15:10 
kk...@talk21.com07 Nov 2002 17:30 
Subject:Re: Newbie Question
From:Friedhelm Betz (holl@gmx.net)
Date:11/07/2002 03:10:56 PM
List:com.mysql.lists.win32

Hallo kkm,

Friday, November 8, 2002, you wrote:

I've got MySQL all nicely set up, and everything sort of works.

However, under Windows there are two accounts which were automatically set up,
root@% and noname@localhost.

I've revoked their privileges OK, but notice they still have the grant_priv
column set to Y, which means that root@% could give privileges to noname@% I
believe.

I've tried deleting these accounts whilst logged in as root@localhost (who can
do everything) using the syntax:

Delete from user where user=' ' and host='localhost';

but to no avail. Any suggestions how I can delete an account with no name ?

Delete from user where user='' and host='localhost' should do the job. With your supplied line:

Delete from user where user=' ' and host='localhost';

you try to delete an entry in user with one space. Please note: user=' ' is not the same as user='' :-)

Thanks for your help, I'm sure this will be the first of many emails !

Consider to get familiar with the fine online Manual at http://www.mysql.com/Manual_chapter/manual_toc.html and take a look in the privileges section.

Regards Friedhelm Betz

Thanks for your help, I'm sure this will be the first of many emails !

-------------------- talk21 your FREE portable and private address on the net at
http://www.talk21.com

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win3@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3@lists.mysql.com instead.

Friedhelm