MySQL Bugs: #40079: Can't change MySQL User Name with MySQL Administrator on Mac OSX

Bug #40079	Can't change MySQL User Name with MySQL Administrator on Mac OSX
Submitted:	16 Oct 2008 13:29	Modified:	14 May 2009 12:42
Reporter:	Paul Keenan	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	MacOS (10.5 (Darwin))
Assigned to:		CPU Architecture:	Any
Tags:	change, username

Description:
It is not possible to change the user name once established in MySQL Administrator on Mac OSX.  The problem is not present on Windows XP.  It is easy enough to work around - delete the user, then create from scratch.

How to repeat:
Open MySQL Administrator on Mac OSX.
Change to Accounts pane.
Add a new user.
Change "newuser" to "Bob"
Click "Save Changes" to create account.
Edit "Bob" to say "Bill"
Click "Save Changes"

User name is not updated in "Accounts" pane.

Quit and restart MySQL Administrator.
Change to Accounts pane.
User name still displays "Bob" in the "Accounts" pane.

Thank you for the report.

Verified on OS X 10.4.

In my case behavior is different: I can rename Bob to Bill, but error is shown and after restart Bob-Bill becomes "newuser" again.

Described behavior I get if after saving Bob I restart MySQL Administrator, then try to change it to Bill.

You are correct, the behaviour I get in 10.5 also is as you describe.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

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