MySQL Bugs: #48871: Configuration Wizard Hangs on Start Service

Bug #48871	Configuration Wizard Hangs on Start Service
Submitted:	18 Nov 2009 16:06	Modified:	23 Nov 2009 15:15
Reporter:	Thomas Riddle	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Config Wizard	Severity:	S1 (Critical)
Version:	5.1.41	OS:	Windows (Windows XP SP2)
Assigned to:		CPU Architecture:	Any
Tags:	configuration, freezes, hangs, service, start, wizard

Description:
Downloaded 5.1.4.0 and installed. Installs OK but when configuring a server instance, the configuration wizard checks off the first two boxes, but on Start Service, the configuration wizard locks up and the process must be killed. I have let it run overnight, and in the morning it is still frozen. If MySQL is not configured to start as a service, the configuration wizard succeeds.

I have tried disabling antivirus, opening the port in my firewall, disabling the firewall. I tried removing MySQL, deleting MySQL registry keys, deleting the service, and then restart and reinstall. Still same behavior.

How to repeat:
Step through the configuration wizard with any combination of options. Enable start MySQL as a service. Click Execute on last page.

Thank you for the problem report. Please, send the results of:

echo %TMP%
echo %TEMP%

from cmd.exe. If some directory is listed, please, check if it exists.

C:\Documents and Settings\admin\Desktop>echo %TMP%
C:\DOCUME~1\admin\LOCALS~1\Temp

C:\Documents and Settings\admin\Desktop>echo %TEMP%
C:\DOCUME~1\admin\LOCALS~1\Temp

I checked if the directory exists, it does. Contained within the directory are the following files:

dwlog.dll - 1KB
libmysqlinstanceconf.dll - 1468KB

I tried to upload the dll to your ftp site like the Files tab explains. The FTP is denying me upload access. The file is also larger than 500KB so I can't attach it.

Here it the ftp error for ftp.mysql.com:

Response:	227 Entering Passive Mode (192,9,72,98,43,23)
Command:	STOR bug-data1-48871.zip
Response:	553 Could not create file.

Could you please provide step by step instructions how to repeat this issue?. Sometimes a simple detail make the behavior not to be repeatable. Thanks in advance.

You were right. If I choose an Multifunctional or Transactional database type using InnoDB, the service fails to start. However, if I use a Non-transactional database, the service starts successfully. I looked in my event log and I received the following MySQL application errors:

The description for Event ID ( 100 ) in Source ( MySQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 

Plugin 'FEDERATED' is disabled.

Plugin 'InnoDB' init function returned error.

Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

Unknown/unsupported table type: INNODB

Aborting

All these errors have the same MySQL error type: 100. Does anybody know what these errors mean?

I just uninstalled, deleted all mysql registry keys, and rebooted. Reinstalled version 5.1.41 msi installation.

Then I performed these exact steps:

-Installed with Typical Config
-Server Instance Configuration Wizard started
-Detailed Configuration
-Server Machine
-Multifunctional DB
-C:\Installation Path
-Decision Support
-TCP/IP Enabled : port 3306
-Strict Mode Enabled
-UTF8 Character Set
-Install as Windows Service and Launch Automatically
-Did not modify security settings
-Press Execute

MySL configuration wizard still hangs on "Start Service". The wizard does not hang if I use non-transactional database. Please advise on a fix.

I looked in my MySQL .err file in the hidden application data folder and found this error:

 InnoDB :: Unable to create temporary file; errno: 2

Helllooo? Does anybody read these? I can't even get MySQL configured....

Finally solved it. It was a combination of McAfee blocking MySQL from registering as a service and not completely uninstalling the MySQL program.

I am having the same issue as of the latest 5.1 stable release.  I am on XP.

Following advice above and choosing 'non transactional database', the wizard was able to get to 'start service'.  Now I get this error message:

"The security settings could not be applied to the database because the connection has failed with the following error.

Error Nr. 1045
Access denied for user 'root'@'localhost' (using password: NO)

If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu."

Firewall is completely off (relevant connection is unchecked in "Advanced" tab), and Exception was added.

These steps finally got me into the "mysql" command with a password on the root user:
1. create service with only non-transactional db, and without security check (uncheck both the set admin pass and create anon options)
2. ensure the mysql service is runnable (using windows task manager, look for mysql.exe)
3. stop mysql service from windows services screen (right click my computer, manage, services)
4. start the service by opening a cmd prompt(1) and going to installationdir\bin\mysqld --skip-grant-tables
4. log into mysql by opening another cmd prompt(2) and running:
mysql -u root
5. open another cmd prompt(3) and run the command "mysqladmin flush-privileges" to enable grant tables again; this is needed for step 5
5. set a password for root user by going to prompt# 2 and enterring:
 SET PASSWORD FOR root@'localhost' = PASSWORD('newpwd'); 

I had no problems with mysql in the past; however, today's experience and the many hours spent on this issue has been frustrating and disappointing.

Please fix this issue.

For the cause of the error 'The description for Event ID ( 100 ) in Source ( MySQL )
cannot be found.' 
and workaround, See Bug #48042.

5.1.50 x64
Windows Server 2008 non-R2 x64
Hangs on Start Service with any setup options

FYI to anyone still having this problem.

The installation wizard was hanging while attempting to install mysql-essential-5.0.92-win32.msi on a Gateway GT5676 running Windows 7 Ultimate. I have installed MySQL and deleted it several times over the past few years and could not get the install wizard to step past the Start Service checkbox. It would simply hang with no error messages.

The solution that worked for me was to edit the registry and remove all references to MySQL.

I rebooted and was able to successfully complete the install.

John, sounds good. But what the registry keys to edit?

My first time trying to install MYSQL.

Having read the above replies I am lost as to which registry entries to remove??

The registry fix worked for me as well. I just searched for and deleted every key and value that contained the string "MySQL" and didn't appear to be related to another program (e.g., PHP). Then I deleted the data folder that the MySQL installation warns you isn't removed when you uninstall MySQL (for me it was C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data).

Thanks for the reply. I am not too confident messing with the registry. I did manage to install on another machine and did nothing at all different, all working well! Registry editing scares me, so I will leave it for now!

View Eric Eskildsen comment at the end. Deleting the MySql directory from the Application Data folder and uninstalling/reinstalling MySql as a service everything worked well. Good work man.

I had this problem today with version Server version: 5.5.9 MySQL Community Server (GPL). Configuration wizard 1.0.17.0.

This actually worked =D whoppa!

I'm just facing the same bug with 5.5.29 on W2K8 Enterprise R2. Cleaning all MySQL occurences in the registry and removing all MySQL directories works !

clearing out the registry and data folders prior to reinstalling mysql did it for me too. i was trying to install mysql 5.5.33. thanks you to those who shared their solutions and workarounds. cheers!

Clearing the Registry entries and deleting "C:\ProgramData\MySQL" folder fixed the issue for me.