2 messages in com.mysql.lists.bugsPossible bug: Anonymous user password...
FromSent OnAttachments
Verdius06 Mar 2002 06:42 
Michael Widenius11 Mar 2002 03:00 
Subject:Possible bug: Anonymous user password setting
From:Verdius (arti@yahoo.com)
Date:03/06/2002 06:42:28 AM
List:com.mysql.lists.bugs

1) If you have an anonymous user and you want to set a password for it, you might use the following command:

mysql> set password for ''@'%'=PASSWORD('new_password');

2) I got the following error:

ERROR 1131: You are using MySQL as an anonymous users and anonymous users are not allowed to change passwords

3) However, I wasn't "using MySQL as an anonymous users", but rather as the main administrator with total grants. I was simply trying to change the anonymous users password. Next i confirm that i'm the main user (username: fullcirc),

mysql>select user(); +--------------------+ | user() | +--------------------+ | fullcirc@localhost | 1 row in set (0.00 sec)

mysql>

4) I do not understand this completely, but at the very least it seems to be a poorly described error here.

5) This is not a problem for me but i just wanted to pass it along as a somewhat responsible user. If i take the time to research a lot of detailed channels for proper bug reporting of every tech i use, i will accomplish very little. I hope this works, or i give up on MySQL bug reporting for a while (actually i did a lot of reporting typos and errors in the mysql.com manual when it was mysql.org, and it seemed appreciated and led to changes, and i was able to send an email that got read.

6) Thanks.