MySQL Bugs: #18638: Service Start Problem

Bug #18638	Service Start Problem
Submitted:	30 Mar 2006 3:16	Modified:	7 Nov 2007 22:04
Reporter:	Vincent Cheung	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	5.0	OS:	Windows (Windows 2000/2003)
Assigned to:	Iggy Galarza	CPU Architecture:	Any

Description:
Bug 1:
Service must stop manually while apply any instance config.
(Because I tested if manually shutdown instance, it works fine. Remember close the system tray monitor.)

But it retain a new problem.

Bug 2:
Port 3306 may be jamed some where.
(Now hold, makes me can't use it.)

How to repeat:
Go through Bug 1 and run Instance Config then EXECUTE.
The problem will shown on screen.

Suggested fix:
For Bug 1:
After any changes (NOT only press EXECUTE), shutdown service instance first is correct.

For Bug 2:
Please check with Administrator, Query Browser and System tray Monitor.

[30 Mar 10:27] Vincent Cheung Dear Vladimir Kolesnikov,

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

1st SYMPTOM:

Uninstall the following keys from the Registry is a must.
1.
[HKEY_CURRENT_USER\Software\ORL\VNCHooks\Application_Prefs\MySQLInstanceConfig.e
xe]
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.[30 Mar 10:29] Vincent Cheung This webpage txt font size is too small. Please adjust.[30 Mar 10: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 11:01] Vincent Cheung 3rd SYMPTOM:

Separate all items from Instance config wizard or selective items which user
need to modify.[30 Mar 11:04] Vincent Cheung Selective for start service to identify the real bug.[30 Mar 11:05] Vincent Cheung Can't start service will makes the setting not modify "Apply security setting".[30 Mar 11:08] Vincent Cheung Select D:\ but data directory also display c:\[30 Mar 11: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 11:30] Vincent Cheung System tray monitor is useful to bundle with DB not Administrator.[30 Mar 11:34] Vincent Cheung Please verify this:

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

Is it just typing missing/mistakes?[30 Mar 11: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 11:56] Vincent Cheung 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.

Thanks for your bug report.  I was able to reproduce both bugs under WinXP64 using 5.0.19

> IF I PROVED IS THE CAPTIONED PROBLEM, WHAT GIFT I HAVE? NOTHING. 

Really ?  The gift you get is knowing you contributed on making MySQL and its GUI tools better applications !

Many thanks.
My own company will transfter all existing DBs to MySQL later.

Anywhy, we both work hard together. ^.^

I found other bug. Please visit:
http://bugs.mysql.com/bug.php?id=18731

Regarding to the database charset.
"Column Charset and collation is not really critical needed".
It is not represent how powerful of MySQL. Just playing.

Reason:
If a company using multi-language to represent their International web.
UNICODE is enough. If a developer set the page as utf-8, he/she wouldn't post data and convert to other charset(big5/gb2312/sjis/latin1), right?

The opposite side, if a developer set the page as big5/gb2312/sjis/latin1, they wouldn't write a program to convert chars to utf-8. And write a program convert utf-8 to other chars(big5/gb2312/sjis/latin1) again then represent to the webpage.
It is wasting the server resources.

I will never use/test MySQL again.
I rather pay money to use MSSQL / Oracle. Bye Bye.

This bug report has several different symptoms.  I'll try to address each one below.  I tested using mysql-5.0.45-win32.msi

Bug #1.  I installed mysql 5.0.45 on Windows XP as a service.  I was able to re-run MySQLInstanceConfig and re-configure the server without manually restarting the service.  This is "Can't Repeat".
Bug #2.  Since I couldn't reproduce Bug #1, I'm can't be sure but I believe this is a duplicate of Bug#24853.

1st Symptom.  I installed the server and clients, configured with the Instance Config Wizard and then uninstalled. 
   Reg Key 1. I do not have HKCU\Software\ORL on my machine. Must be from some other software.  Maybe Oracle?
   Reg Key 2. This is an installer key.  These directories are left because they contain your data.  Won't fix.
   Reg Key 3. See above.
   Reg Key 4. I don't have this key present.  This key is dynamic and managed by Windows.  It's a backup for HKLM\SYSTEM\CurrentControlSet. Not a bug.
   Required restart will vary depending on the version of Windows being used.  I did not need to restart my system to complete the uninstall.
2nd Symptom.  See http://dev.mysql.com/doc/refman/5.1/en/mysql-config-wizard-security.html for a description of this feature.
3rd Symptom.  I honestly just don't understand this part. 
Using Administrator. My config file name and path did not change.  The service has no description. Bug#28628 is described next.  Finally, I had no problem installing to my D drive.