MySQL Bugs: #11452: Service Control and Startup Variables sections works only for first instance

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:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.21	OS:	Windows (Windows Server 2003)
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

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

Not Wondows :-) but Windows

Thanks for the bug report.

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
    http://www.mysql.com/doc/en/Installing_source_tree.html

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"
4. 
[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL]
"EventMessageFile"=hex(2):43,00,3a,00,5c,00,50,00,72,00,6f,00,67,00,72,00,61,\
  00,6d,00,20,00,46,00,69,00,6c,00,65,00,73,00,5c,00,4d,00,79,00,53,00,51,00,\
  4c,00,5c,00,4d,00,79,00,53,00,51,00,4c,00,20,00,53,00,65,00,72,00,76,00,65,\
  00,72,00,20,00,35,00,2e,00,30,00,5c,00,62,00,69,00,6e,00,5c,00,6d,00,79,00,\
  73,00,71,00,6c,00,64,00,2d,00,6e,00,74,00,2e,00,65,00,78,00,65,00,00,00
"TypesSupported"=dword:00000007

And noted to user, they need to restart their PC/Server.

This webpage txt font size is too small. Please adjust.

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.

3rd SYMPTOM:

Separate all items from Instance config wizard or selective items which user need to modify.

Selective for start service to identify the real bug.

Can't start service will makes the setting not modify "Apply security setting".

Select D:\ but data directory also display c:\

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

System tray monitor is useful to bundle with DB not Administrator.

Please verify this:

[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services]
"Description"="MySQL Ser"

Is it just typing missing/mistakes?

Error 2003
Can't connect to MySQL server on 'localhost' (10061)

The captioned problem will only affected while install. Just click Retry then Ok.

As I test the whole day.
I found the best shit bug inside.
It is DATA PATH.

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

PLEASE MAKE IT SMOOTHLY.
IF I PROVED IS THE CAPTIONED PROBLEM, WHAT GIFT I HAVE? NOTHING. 
TIPS: Cafe is not clean, you will not get in.