MySQL Bugs: #44175: User Administration and Server Connections menu items crash Administrator

Bug #44175	User Administration and Server Connections menu items crash Administrator
Submitted:	9 Apr 2009 3:28	Modified:	16 Oct 2009 10:22
Reporter:	Wayne Fuller	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.2.17	OS:	Other (Windows XP sp3)
Assigned to:		CPU Architecture:	Any
Tags:	CHECKED, Server Connections, user administration

Description:
Administrator comes up ok, however once there I get the following errors:

1. User Administration menu selection - Could not fetch user names - SELECT command denied to "@'localhost' for table 'user' (1142). Clicking on "Add new user" button gives me a "Access violation" error and the "add new user" button goes gray, and stays that way.  No other actions are possible.

2.Server Connections menu selection - get "Could not fetch Process list" (Access dinied, you need the PROCESS privilege for this operation (1227)).  Another "Access violation" and I have to abort the Administrator.

How to repeat:
Not sure, every time I open "Administrator", I get these errors.

Thank you for the bug report. Verified just as described if connected as non-privileged user, like this one:

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -uuser1  -P3308 test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 42
Server version: 5.0.79-enterprise-gpl-nt MySQL Enterprise Server - Pro Edition (
GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show grants;
+-------------------------------------------------------------+
| Grants for user1@%                                          |
+-------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user1'@'%'                           |
| GRANT SELECT, INSERT ON `data_base`.* TO 'user1'@'%'        |
| GRANT ALL PRIVILEGES ON `test`.`nonexistant` TO 'user1'@'%' |
+-------------------------------------------------------------+
3 rows in set (0.01 sec)

This crash does NOT happen if you connect as root, for example.

I'm sure you understand everything you said, but I don't.  What is it you are saying I should do to get past this problem, or is it something you need to work on first?

I'm not sure why I have an administrator GUI, if I can't do administrative functions, and why any part of the app would require me to abort the app just because I am not logged in as a particular user type?  As an administrator, shouldn't my login be an administrative login by default?

Thanks,
Wayne

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. We won't add this feature request anymore.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/