Bug #13221 can't Edit table when current user hasn't a password
Submitted: 15 Sep 2005 12:12 Modified: 15 Sep 2005 16:48
Reporter: Mickael Besson Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.21 OS:Windows (Windows XP pro SP2)
Assigned to: MySQL Verification Team CPU Architecture:Any

[15 Sep 2005 12:12] Mickael Besson
Description:
We can't "Edit table data" on a table in catalog when current user has got no password. MySQL QueryBrowser can't be opened.

"Access denied for user root..."

How to repeat:
try with :
login : root
pwd : <nothing>
[15 Sep 2005 16:48] MySQL Verification Team
I was unable to repeat the behavior reported with default install
privileges:

mysql> select user, password from user where user='root';
+------+----------+
| user | password |
+------+----------+
| root |          |
+------+----------+
1 row in set (0.02 sec)

mysql> show grants for root@localhost;
+---------------------------------------------------------------------+
| Grants for root@localhost                                           |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>