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:
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

[17 Jun 2008 16:52] Chris Wilson
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.
[17 Jun 2008 17:02] MySQL Verification Team
Thank you for the bug report.
[20 Sep 2008 14:31] Mike Lischke
Fixed in rev. 689
[7 Oct 2008 9:10] Mike Lischke
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