MySQL Bugs: #14375: Can not configure MySQL Server 5.0 in Windows XP Professional

Bug #14375	Can not configure MySQL Server 5.0 in Windows XP Professional
Submitted:	27 Oct 2005 6:17	Modified:	2 Nov 2005 12:19
Reporter:	NILANJANA CHOUDHURY	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S1 (Critical)
Version:	5.0.15	OS:	Windows (Windows XP Professional SP2)
Assigned to:		CPU Architecture:	Any

Description:
I have installed the MySQL server 5.0 in Windows XP Professional with the
essential installer (mysql-essential-5.0.15-win32.msi). While configuring MySQL Server Instance with the MySQL
Server Instance Configuration Wizard, I am repeatedly getting the following error message when I click on the execute button in the last page of the MySQL
Server Instance Configuration Wizard :
"The security settings could not be applied to the database because the connection has failed with the following error. Error Number 2003. Can't connect to MYSQL server on 'localhost' (10061)". 

I have the McAfee Personal Firewall Plus running in my machine and opened the port 3306 for MySQL. I tried repeatedly by removing the Server Instance and then reconfiguring, but everytime I am getting the same error.

Here is my .err file.

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
051026 23:09:23  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
051026 23:09:23  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
051026 23:09:24  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
051026 23:09:26  InnoDB: Started; log sequence number 0 0
051026 23:09:26 [ERROR] Aborting

051026 23:09:26  InnoDB: Starting shutdown...
051026 23:09:28  InnoDB: Shutdown completed; log sequence number 0 43655
051026 23:09:28 [Note] C:\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

051026 23:14:01  InnoDB: Started; log sequence number 0 43655
051026 23:14:01 [ERROR] Aborting

051026 23:14:01  InnoDB: Starting shutdown...
051026 23:14:03  InnoDB: Shutdown completed; log sequence number 0 43655
051026 23:14:03 [Note] C:\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

051026 23:15:33  InnoDB: Started; log sequence number 0 43655
051026 23:15:33 [ERROR] Aborting

051026 23:15:33  InnoDB: Starting shutdown...
051026 23:15:35  InnoDB: Shutdown completed; log sequence number 0 43655
051026 23:15:35 [Note] C:\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

051026 23:16:27  InnoDB: Started; log sequence number 0 43655
051026 23:16:27 [ERROR] Aborting

051026 23:16:27  InnoDB: Starting shutdown...
051026 23:16:29  InnoDB: Shutdown completed; log sequence number 0 43655
051026 23:16:29 [Note] C:\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

How to repeat:
Configure MySQL Server Instance with the MySQL Server Instance Configuration Wizard.

Thank you for a problem report. Have you installed any versions of MySQL on this machines before?

Can you, please, try to completely switch off your firewall temporary and repeat the configuration process? Please do it and inform about the results.

Flow of actions

Attachment: Error.html (text/html), 1.97 KiB.

error1

Attachment: Error_html_5ae7993.jpg (image/pjpeg, text), 28.63 KiB.

error2

Attachment: Error_html_5d1ff4e3.jpg (image/pjpeg, text), 43.38 KiB.

error3

Attachment: Error_html_7b02abfb.jpg (image/pjpeg, text), 43.10 KiB.

error4

Attachment: Error_html_33b581f7.jpg (image/pjpeg, text), 38.62 KiB.

error5

Attachment: Error_html_63ec9e99.jpg (image/pjpeg, text), 40.76 KiB.

error6

Attachment: Error_html_m745be5ef.jpg (image/pjpeg, text), 32.67 KiB.

Thanks for your attension. I previously tried to install MySQL Server 4.1 a few days back but the configuration wizard was failing to start the windows sevice at that time. So I completely removed the server instance using the MySQL Server Instance Config Wizard, then removed the server using Windows 'Control Panel' and the 'Add/Remove Program'.
Then I am trying to install and configure the MySQL Server 5.0.
As advised by you I completely disabled my 'McAfee Personal Firewall Plus' and then tried to configure the server instance. But the process failed exactly the same way it was failing before, i.e., when I click on the execute button in the last
page of the MySQL Server Instance Configuration Wizard, I get the following error :
"The security settings could not be applied to the database because the
connection has failed with the following error. Error Number 2003. Can't
connect to MYSQL server on 'localhost' (10061)". 

Please see attached error1 (Error_html_5ae7993.jpg), error4 (Error_html_33b581f7.jpg) and error6 (Error_html_m745be5ef.jpg) files to see the screen prints of the error I am getting.

Thank you for the additional information. As you tried to install the MySQL server before, the last paragraph on the dialog box presented in Error_html_33b581f7.jpg may apply to you. So, please, deinstall the server completely using Windows Add/Remove programs (it will delete the instance too), the go to the C:\Program Files\ and remove MySQL\MySQL Server * directories completely (or just remove everything from the data directory where you created it). Then repeat the installation attempt, with firewall switched off, and inform about the results. 

If you will get the same error message, please, open the cmd.exe command line window, execute the 

netstat -a > c:\netstat.txt 

command and send the content of that file here.

Do you have a "plain" XP Pro or any service pack installed?

I have Windows XP Professional Service Pack 2.

OK. I have to try with XP SP2 (my current 5.0.15 is running on plain XP). In the meantime, please, look at the similar bug report:

http://bugs.mysql.com/bug.php?id=7548

This it the first known reason for similar problem (as we proved by netstat -a, you have no other instance running on the same ports) - you may have your data directory left from the previous installation. It may not be in c:\MySQL, but in \Program files... So, please, check, and delete if any.

The second reason I know about is some entries left in the registry from the old installations. So, please, uninstall once more and then try to find all the entries in the registry with "mysql" and delete those of them that refer to this in previous version of the server. Use regedit and its search menu items for that. 

Inform about any directories and/or registry entries found after stadard uninstall procedure.

After that try to install 5.0.15. I'll try to do it today or tomorrow on SP2 too.

Hi Valeriy,

Thanks for your help. I am still unsccessful in configuring the server. First I uninstalled the MySQL server 5.0 using 'Add/Remove Program'. Then deleted the Data directory. I searched the 'Program Files' and there was no MySQL folder under that. Then I searched the registry for MySQL and deleted every occurance of that. Then I reistalled MySQL with my firewall disabled. During server configuration the same old error came.

I've just tried with my home XP SP2 and mysql-essential-5.0.15-win32.msi yesterday. Here is the brief of steps I performed to install it over previous 5.0.13-rc.

1. I deinstalled previous version using Control Panel | Add Remove programs

2. I perfromed a complete install into the c:\Program Files\MySQL\MySQL Server 5.0 (the same directory 5.0.13-rc was installed to), as it is supposed by default.

3. I configured the instance, by default, on port 3306, with service name MySQL, and provided new password for root.

4. On the last screen I've got the same error message as you got (because I used the same old data directory, and root password was different).

At this moment, you can just click Cancel in the dialog box, and you will have 5.0.15 up and running (try mysql command line client), but with empty root password (so you'll not need to provide a password when connecting as root). You can add some security later...

But, to get a clean installation, I had performed the following next:

5. I deinstalled 5.0.15 using Control panel, deleted the entire MySQL directory from c:\Program Files, and deleted 5.0.15 key from HKEY_LOCAL_MACHINE\Software\MySQL in the registry. Then I repeated the same installation steps from the beginning. And it worked.

I even have a screenshots of the entire process (23 or so). I can post some of them here, if you want.

Summary:

It is not a bug. MySQL 5.0.15 installs on XP SP2, with firewall and security services switched off, each and every time, using the described procedure. If you can't repeat this istallation, you may ask for help in forums or even use our commercial support. But there is no bug to discuss about it here.

I am experiencing the same issues NILANJANA reports. Initially, MySQL loaded fine, MySQLAdmin worked fine. In fact, worked better than the same install I completed on my XP Pro/SP2 pc at home. Then I loaded Migration Toolkit, test ran importing a MS-Access table. When the Toolkit Wizard wanted location and security information for the Access tables, I input my pc's name, path on my harddrive, and my Novell login information. Second guessing myself, probably should have left everything blank, force the Wizard to prompt me. Now I'm in the same position as NILANJANA - no matter how I un-install/install, MySQLAdmin issues 1045 errors logging into local host, pings fine. Would like to use MySQL for website developing.

Ok I have experience the same problem and I have an work round, At the final stage of the configuration when press execute the instance will fail and the solution to that will be:

Go to control panel click personal firewall and then click exception -> Add Program -> then select mysqladmin from the bin directory where you have install you MySQL instance and then press the pop up from MySQL (Retry) the configuration should then be complete 

Make sure the same routine apply for mysql instance as well i.e. from the same dialog within the control panel you should see the running MySQL instance.
I am running XP Professional Service Pack 2 machine

Dear Valeriy Kravchuk;

I don't know if you still follow this thread or not (I sincerely hope you do still follow this thread).  I have installed MySQL 5.0.27 on my Windows XP Professional system and I have the exact same problem configuring up a server instance as NILANJANA CHOUDHURY mentioned having.  In your last reply you stated that the problem NILANJANA had is not a bug and that the server instance should be configured with the Windows Firewall turned off.  You based your statement on the fact you successfully configured the server instance on your "home XP SP2" with the firewall turned off.

Is the Windows system on which you successfully configured the server instance a Professional Edition or a Home Edition?

Thanks!
Steve.

Right now I can test with XP SP2 Home Edition only (and it works, up to current 5.0.27). 

If you refer to my comment dated 2 Nov 2005 13:19, I'll have to double check my home machine where screenshots were made (as it is really at home and used by my family). I'll add comment about exact version next week.

Hi Nilanjana, are you using same machine as server and client?? if so then after removing server (MySQL) you also have to remove client (e.g. MySQLyog).

Then only you'll be able to reinstall Mysql server properly else it'll not allow you to open the port and perform the security settings.
Hope it'll work for you... 
Please reply me back on maheshbest@gmail.com