2 messages in com.mysql.lists.bugsPossible bug: Anonymous user password...| From | Sent On | Attachments |
|---|---|---|
| Verdius | 06 Mar 2002 06:42 | |
| Michael Widenius | 11 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.
__________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/




