MySQL Bugs: #17730: Configuration Wizard Hangs

Bug #17730	Configuration Wizard Hangs
Submitted:	27 Feb 2006 0:56	Modified:	9 Oct 2010 5:17
Reporter:	Michael Nelson	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Config Wizard	Severity:	S1 (Critical)
Version:	5.0.18	OS:	Windows (Windows 2003)
Assigned to:		CPU Architecture:	Any

Description:
Installed MySQL on Windows 2003 Server with all latest service packs. (Not RC2).
Installs OK. MySQL service is running. Run configuration wizard and hangs when
EXECUTE button is pressed on last page. No other information is given. No errors in event viewer. Cannot find any error messages in MySQL. 

Tried changing the service account to administrator. Tried setting up a new account. The service stops and starts fine. 

New to MySQL, but cannot see anything wrong with installation.

How to repeat:
Load MySQL on Windows 2003 server and run the configuration wizard. Wizard hangs on last screen.

4.1 installs and configures on the same server with no problem.

Thank you for a problem report. Had you tried to install MySQL as local Administrator? If no, please, uninstall it and try again.

If yes, please, send the results on netstat -a command. I want to check, that port 3306 is not used.

Results of netstat -a

Attachment: Mysql_netstat.txt (text/plain), 2.14 KiB.

Yes, I tried to reinstall under administrator and also as a new account with admin rights.

I have uploaded Mysql_netstat.txt which shows the results of netstat -a. It was run when attempting to run the config wizard. The config wizard locks up.

I have also uploaded a screen shot of an error message. I check and Windows Firewall is not running and not configured. I also double checked removal of other data files, etc.

Screen shot of error and config wizard hang

Attachment: MySQLError.doc (application/msword, text), 55.00 KiB.

Netstat prior to installation

Attachment: Mysql_netstat_prior.txt (text/plain), 1.88 KiB.

Netstat after installation

Attachment: Mysql_netstat_afterinstall.txt (text/plain), 1.93 KiB.

Netstat after installation, during config wizard

Attachment: Mysql_netstat_duringconfig.txt (text/plain), 1.94 KiB.

With firewall service on but filtering off

Attachment: Mysql_netstat_withfirewallon.txt (text/plain), 2.16 KiB.

with firewall service on and port 3306 open

Attachment: Mysql_netstat_withfirewallportopen.txt (text/plain), 2.21 KiB.

I tested several other options. Files are attached:

Netstat before installation.
Netstat after installation.
Netstat after installation, during config wizard hang.

All the above were run windows firewall service disabled.

Windows firewall service was not running. I turned the service on but left firewall off.
Opened port 3306 on windows firewall.
Ran netstat under both circumstances.

I also got this problem.

But at the first time installation is no problem and works fine.

I tested, sometimes can't "Start service" and sometimes can't "Apply security settings".

I tested if run "Reconfigure Instance" or "Remove Instance" again.
It could not restart the service or apply new settings.

Suggestion:
For "Service":
When execute the new settings, stop the service 1st before start.

Actually, I'm not hang at configuration wizard.
Just can't start service & apply new security.
At last, I lost the password.

Michael,

Please, try to repeat with a newer version, 5.0.20, AND (most important) if you'll get an error message that you can not connect to service, try again (there is a button to repeat). When you create a completely new instance with InnoDB support (as it is by default), service will need some time to initialize InnoDB tablespace and logs, and MySQL server will not accept connection (to apply security settings) during this process. So, trying again after several seconds can (and, in many know cases, do) help.

But 5.0.20 does not fix my proved problems BUG#18638.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

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

I am also downloaded the mysql-essential-5.1.39-win32 file and started installation. Unfortunately, wizard is locked without performing any task mentioned in the wizard.(i.e. Prepare configuration, write configuration file, etc).
I dont know what to do?
any help on this.

Same over here!

I was also 100% percent positive about mysql as the solution for many, but this issue is causing me too much stress.

Still no news about this issue?

unfortunately no reply mysql. I tried uninstalling and installing but no luck.

wizard is sucessfull if you dont enter any user id and password for server.
Next problem is, when I launch mysql administrator, it will give another user error.

I have the same issue. Configuration wizard hangs when trying to start the service. What a piece of crap.

After too much time and frustrations I found out that XAMPP did the job for me. Instead of tweaking and twisting your registry just install XAMPP and just use the services you want (I only use MySQL and FTP services). Ofcourse you might need to alter your log size for better performance.

I had the same problem on Windows 2008. The configurator just hangs without performing any of the steps. On my fourth try it ran successfully, and the only change I made was to change the initial root password from 'admin' to 'hello'. So possibly MySQL doesn't like 'admin' as a password is the only thing that makes sense to me.

I have the same problem on Win XP Prof SP 3. The wizard hangs on the last page after I press execute (the first 2/4 items are applied, but then it hangs).

hi, well i had the same problem ....
well solution for me was that i changed installation dir:
ex: C:\mySql\MysqlServer5.x.x to C:\MySql\MySqlServer5

Thank you, ales allesio.
I changed the installation-directory and now it works.

Greetings, I've had the same problem on both Windows 7 and Windows Server 2003. I came across this thread, and thought I'd mess around a bit, which ended up being an hour and a half. However, I think I have found the solution to the problem.

The problem is with InnoDB, if it has initialized before, the second time it won't be able to, since one of its files is not zero-sized, and therefore its constructor will throw an exception, causing the configuration wizard to freeze.

The InnoDB rubbish is located in "C:\ProgramData\MySQL\MySQL Server 5.1\data" by default, and there will be a {machine name}.err file in there. If you open that in notepad and find an error message saying that, the solution is to simply uninstall MySQL, and remove that folder in its entity after you have uninstalled.

So basically, uninstall, remove the "C:\ProgramData\MySQL\" folder entirely, and reinstall. After doing that, the configuration utility did not freeze anymore on my two machines, and MySQL is now properly running.

Hope that helps!
Regards.

Martijn,

your problem is duplicate of bug #56851

Please help me
after installation mysql 5.1.53
mysql server instance configuration in last step after clicking execute 
it hangs in start service.
i cleared register key with ccleaner,
i tried with firwall Off.
still i'm not getting it.

Hi,
I am using Windows Vista. Today I installed MySql.When I run Mysql Server Instance Configuration Wizard, it gets stuck at "Start service" and did not throw any error.
Please Help me...

@jerald m
Did you try to change the installation directory, as here discripted?

thank you i changed installation directory it works :-)

I think I am having the same problem: config wizard gets to the "execute" page. As soon as I click execute it freezes.

Have tried the trick with manually deleting directories but it has not yielded any joy :(

Thoughts?

@Henry Lauer
Did you read some posts here?
once again:
Did you try to change the installation directory, as here suggested?

Thanks for you help...but it doesn't seem to help when I install to another directory than the default (that is what is meant, right?)

yes, just another directory than the failed attemps before... works for some

I had this problem today. We solved it by removing the folder in : C:\Documents and Settings\All Users\Application Data\MySQL

Good Luck.

This bug still exists, even on 5.5.

If you have installed then uninstalled mysql, the next install will never successfully start service in the wizard.

Deleting mysql folder from program files before installation does not help.

Deleting %ALLUSERSPROFILE%\application data\mysql before installation fixed the problem for me.

I tried all of the above and it still didn't work.

THEN I tried all of the above AND removed all references to MySql from the registry - and it worked!

At the end of the mysql installation, uncheck Start the Instance Wizard.
Then go to wherever you installed mysql/bin and start the Instance Wizard as an Administrator. Solved it for me.

I tried many combinations of the above and none solved my problem. What finally solved it for me was cleaning the registry, I couldn't find the registry key mentioned above but I have had mysql installed standalone and as part of Xampp. I used Ccleaner's registry tool.

This really is a duplicate of Bug#13494, which will be fixed in MySQL 5.6.8.