Bug #6346 can't add hosts to users in user administration
Submitted: 31 Oct 2004 14:09 Modified: 4 Nov 2004 10:39
Reporter: - - Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.13 OS:Windows (ms windows xp pro sp2)
Assigned to: CPU Architecture:Any

[31 Oct 2004 14:09] - -
Description:
I can't edit User profiles within the mySQL Adminstrator.
It's only possible to add new users.

When I am trying to add hosts I gain an "1062 duplicate entry" error.
But the host (which exists - tested it with phpMyAdmin) isn't displayed within the user administraion-sidebar (even if I doubleclick the user).

So all privileges that I want to add to the user disappear.
mySQL Administrator only adds privileges to the user when a host is visible.
But after I "Apply Changes" the host disappears again from the sidebar.

How to repeat:
* installed mysql server 4.1.7 with "old passwords" cause my php is an old version :)
* installed the mysql adminstrator 1.0.13
* tried to edit a user profile (adding hosts, adding privileges)

Suggested fix:
-
[3 Nov 2004 19:07] Michael G. Zinner
Could you please try with the new release 1.0.14 which addresses also other issues in the user administration.

Please state here if the error still exists.
[3 Nov 2004 21:57] - -
thanks for the help.
the error doesn't appear in the new version.