MySQL Bugs: #44347: Unable to edit user in User Administration

Bug #44347	Unable to edit user in User Administration
Submitted:	17 Apr 2009 19:10	Modified:	19 May 2009 12:58
Reporter:	minkbear minkbear	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.2.17	OS:	Windows (Vista)
Assigned to:		CPU Architecture:	Any
Tags:	CHECKED, user administration

Description:
Unable to do:
1. Can't edit any users at all 
2. Cannot amend Schema Privileges for users either. 
3. Cannot delete users.

From: http://forums.mysql.com/read.php?34,217643,254958#msg-254958

How to repeat:
1. open mysql administrator and log into db as root.
2. select "user administrator".
3. left click at any user you want so the user detail does not show on the right side.
4. right click at any user you want so the following menu is disabled:
- Clone user
- Delete user
- Add host form which the user can connect
- Remove host form which the user can connect

Screenshot

Attachment: Mysql_admin_bug.jpg (image/jpeg, text), 159.46 KiB.

Thank you for the problem report. What MySQL server version are you working with? Is it local or remote?

MySQL Server: MySQL 5.1.32 - community

Sorry, for my many posts.

Just look at the other question, "Is it local or remote?".
answer: local.

Thank you.

Thank you for the feedback. Could you please verify if your root account has host besides the localhost if no, then try to add the % host and test again. See the Manual: 13.2. User Accounts. Thanks in advance.

I am sure that my root account has host besides the localhost.
Let me explan. Looking into `mysql`.`user` I found:
localhost, root
%, root

so it's still happened what i posted before.

Thank you.

Moreover, I try to do this:
1. add new user "test" and click "Apply changes". It works.
2. right click on "test" and click "Add host form which the user can connect"
3. input "127.0.0.0" and click OK
4. click "Apply changes". It show message box, 
"Error while storing the user information. The user might have been deleted. Please refresh the user list."
and show another is command dos box saying that 
"** Message: save user: can't retrieve user information"

the screenshot will be post.

Thank you

Another bug.

Attachment: My_admin_bug.jpg (image/jpeg, text), 206.29 KiB.

Have same problem with mysql 6 alpha (all versions)

This is repeatable for super users with more then one host.

Workaround is to use CLI here.

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 fix this anymore in MySQL Administrator and will have a better solution here in Workbench.

More informations about MySQL Workbench you will find here:

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

I believe I had this same problem on Friday and found a way around it! Steps to follow (Based on Windows install):

Disclaimer: I am not a MySQL expert!

1) Do a full backup of all you databases (and write down information about all user accounts, rights, access, etc).
2) Make a copy of your MySQL directory (Optional). [Shutdown MySQL first]
3) Uninstall MySQL and reboot.
4) Reinstall.
5) You might need to run the 'MySQL Server Instance config wizard' a few times before you get access to editing users. Reset security, and specify a password.
6) You should now have access to editing user 'root'. If not goto step 5)
7) Restore you databases. BUT.... Do not restore database 'mysql'!!! If you do this it will corrupt your user rights.
8) manually add all user accounts and grant permissions.
9) Pat yourself on the back.

The above assumes you are or have upgraded from an older version of MySQL. I can't say it will work for everyone, but it worked for me.

Note: I found it was possible to switch between version on MySQL. Simply shutdown the server, rename the main directory (including the data directory), rename the backup of your old version to the current name, and restart the server. This is good if you forgot to write something down. You might need to look in your Windows registry to find out from where it is going to start the service. Also, have a look at your my.ini file. In old versions I believe this was under C:\windows. For me it was easy as everything is under d:\mysql

I hope this is helpful to someone.

Hi all!
I have the same Problem - no User changes are posible!
In MySql Administrator i get the Message:
mysql save user: can't retrieve user information

I have tried the solution from Steven Kerr and it works well if you have an
old functionaly mysql server!
Steps:
Shut down the mysql service from the machines

Copy the mysql Folder (in the data directory) from the old mysqlserver 
to the data directory of the new one.

Start the mysql service 
Done!

Use MySQL Workbench to edit users.  MySQL Query Administrator is just broken never to be fixed.

A Workaround for MySQL 5.5+ is to manually create the user_info table:

[code]
CREATE TABLE  `mysql`.`user_info` (
  `User` varchar(16) collate utf8_bin NOT NULL,
  `Full_name` varchar(60) collate utf8_bin default NULL,
  `Description` varchar(255) collate utf8_bin default NULL,
  `Email` varchar(80) collate utf8_bin default NULL,
  `Contact_information` text collate utf8_bin,
  `Icon` blob,
  PRIMARY KEY  (`User`),
  KEY `user_info_Full_name` (`Full_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Stores additional user information';
[/code]