MySQL Bugs: #37452: Access violation when adding host to user in MySQL Administrator

Bug #37452	Access violation when adding host to user in MySQL Administrator
Submitted:	17 Jun 2008 16:52	Modified:	7 Oct 2008 9:10
Reporter:	Chris Wilson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	Windows
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	mysql administrator access violation crash adding host

Description:
MySQL Administrator crashes with an Access Violation at address 005F70DA due to read of address 0000002C. Happens when adding a host to a new (not yet saved) user when the 'Show hosts in user list' was previously off.

After this the MySQL database is in a weird state that causes MySQL Administrator to have an Access Violation each time it's started until the databases are deleted.

How to repeat:
Install MySQL server 5.0.51 and MySQL Administrator.
Open MySQL Administrator.
Select User Accounts.
Right-click on the list of users and ensure that Show Hosts is turned off.
Add a new user.
Enter a user name and password.
Before applying changes, right-click on the new user and choose Add a host.
You will see the "Option Change: In order to add and edit host entries" prompt. Choose Yes.
Enter 192.168.0.% as the host wildcard.
Access violation occurs.

Close User Administrator and open it again. Access violation occurs immediately after login.

Suggested fix:
Perhaps the user is in the process of being renamed (not complete yet) when the host is added, so the host is added to a nonexistent user name.

Thank you for the bug report.

Fixed in rev. 689

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html