Bug #6707 Startup Variables in Administrator not working with multiple servers, mysqld1
Submitted: 18 Nov 2004 22:19 Modified: 24 Nov 2004 1:47
Reporter: Tod Carrier Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.0.14 OS:Linux (Red Hat Ent Linux)
Assigned to: Alfredo Kojima CPU Architecture:Any

[18 Nov 2004 22:19] Tod Carrier
Description:
IF there are multiple MySQL servers running on the same machine, then MySQL Administrator v1.0.14 not fully working with MySQL v4.1.7.  Features that are not working include all of Startup Variables.  These are all greyed out and non-functional.

I am running Administrator in an XWindows session in Windows, that connects to a Red Hat Enterprise Linux v3.0 machine.  The Administrator binary is from Linux.  So Administrator IS running locally.  This is a different error than the expected error and similar behavior you get if not running from localhost.

The text at bottom of window indicates that Administrator is reading the 'mysqld' section of the configuration file.

How to repeat:
Set up a machine with multiple servers, just 2 would demonstrate problem.  In the configuration file you will have these sections: 'mysqld_multi', 'mysqld1', and 'mysqld2' - note that you will NOT have a 'mysqld'.

Suggested fix:
Use the port number to determine which configuration section that server uses and use that section, for example 'mysqld1', instead of the default 'mysqld'.
[24 Nov 2004 1:47] Alfredo Kojima
Hi Tod,

I have added a dialog that is shown when you have more than 1 section starting with mysqld.
You may select the section you want to edit from there.

The fix should be available in the next release, to be released soon.