Bug #11452 Service Control and Startup Variables sections works only for first instance
Submitted: 20 Jun 2005 10:25 Modified: 8 Jul 2005 11:18
Reporter: Dmitri Kashtanov Email Updates:
Status: Closed Impact on me:
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.21 OS:Windows (Windows Server 2003)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[20 Jun 2005 10:25] Dmitri Kashtanov
When two instances of MySQL server (as services with names MySQL4 (port 3306) and MySQL50 (port 3309)) are installed and I have connected to second instance at port 3309 (MySQL50), Service Control and Startup Variables sections show information about and manage only first instance of MySQL server (MySQL4 service).

However, when launching MySQL Administrator from MySQL System Tray Monitor's menu -> Actions -> Manage MySQL Instances, there is list at bottom left with all available instances and that is only and uncomfortable way to manage state and settings of second instance with MySQL Administrator.

How to repeat:
All actions below should be performed on same computer
Install MySQL server v4.1.(7 or 9) as service with name MySQL4 (port 3306)
Install MySQL Administrator 1.0.21
Install MySQL server v5.0.7 as service with name MySQL50 (port 3309)
Connect to MySQL server instance at localhost:3309
Service Control and Startup Variables sections show information about MySQL4
[20 Jun 2005 10:27] Dmitri Kashtanov
Not Wondows :-) but Windows
[20 Jun 2005 18:41] MySQL Verification Team
Thanks for the bug report.
[8 Jul 2005 11:18] Vladimir Kolesnikov
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 bugfix, yourself. More information 
about accessing the source trees is available at
[30 Mar 2006 8:27] Vincent Cheung
Dear Vladimir Kolesnikov,

If you developers don't clarify this problem then let me show you what you need to improve.

Uninstall the following keys from the Registry is a must.
1. [HKEY_CURRENT_USER\Software\ORL\VNCHooks\Application_Prefs\MySQLInstanceConfig.exe]
2. [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\Folders]
"C:\\Program Files\\MySQL\\MySQL Server 5.0\\data\\"="1"
"C:\\Program Files\\MySQL\\MySQL Server 5.0\\"="1"
"C:\\Program Files\\MySQL\\"="1"
"C:\\Program Files\\MySQL\\MySQL Server 5.0\\data\\mysql\\"=""
3. [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components\9CE51F4E892C91C4AB43B682E082F9D2]
"00000000000000000000000000000000"="C:\\Program Files\\MySQL\\MySQL Server 5.0\\data\\mysql\\columns_priv.frm"

And noted to user, they need to restart their PC/Server.
[30 Mar 2006 8:29] Vincent Cheung
This webpage txt font size is too small. Please adjust.
[30 Mar 2006 8:48] Vincent Cheung
For the time being, restart server is out-of-date.

Second Symptom:

Noted user to check the box of "Enable root access from remote machine".
Otherwise, run "Administrator", "Query Browser" will prompt error.
[30 Mar 2006 9:01] Vincent Cheung

Separate all items from Instance config wizard or selective items which user need to modify.
[30 Mar 2006 9:04] Vincent Cheung
Selective for start service to identify the real bug.
[30 Mar 2006 9:05] Vincent Cheung
Can't start service will makes the setting not modify "Apply security setting".
[30 Mar 2006 9:08] Vincent Cheung
Select D:\ but data directory also display c:\
[30 Mar 2006 9:22] Vincent Cheung
I would like to upload files to show you. But no rights.... Fine.

Using Administrator:

After remove Service:-
Config Filename and Path to binary will change as below: (Problem?)

C:\Program Files\mysql\my.cnf
C:\Program Files\mysql\bin\mysqld-opt
[30 Mar 2006 9:30] Vincent Cheung
System tray monitor is useful to bundle with DB not Administrator.
[30 Mar 2006 9:34] Vincent Cheung
Please verify this:

"Description"="MySQL Ser"

Is it just typing missing/mistakes?
[30 Mar 2006 9:49] Vincent Cheung
Error 2003
Can't connect to MySQL server on 'localhost' (10061)

The captioned problem will only affected while install. Just click Retry then Ok.
[30 Mar 2006 9:56] Vincent Cheung
As I test the whole day.
I found the best shit bug inside.

Most error will not affect when the user install using C:\
If user select other drive then problem will prompt.

TIPS: Cafe is not clean, you will not get in.