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
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.12 OS:Microsoft Windows
Assigned to: Mike Lischke Target Version:
Tags: mysql administrator access violation crash adding host
Triage: D3 (Medium)

[17 Jun 2008 16:52] Chris Wilson
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.
[17 Jun 2008 17:02] Miguel Solorzano
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

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