Configuring a MySQL 5.1 Instance on Windows 7 Professional x64 Fails

Question

I'm trying to set up my laptops to function as mobile development environments. Installing the software on my Linux machine and getting it configured was fairly straightforward, however I'm having trouble getting MySQL 5.1 Server installed and configured on Windows 7 Professional 64-bit. I'm currently using the Windows MSI Installer for the complete MySQL 5.1 system (as opposed to the Essentials installer also available). I've tried to install using both the 32-bit and 64-bit versions of MySQL 5.1 - the same events occur in both.

I've installed both the Server Instance Configuration Wizard and Workbench and everything appears to be installed just fine. When I open the Instance Configuration Wizard, I select Detailed Configuration. On the next screen, I select Development Environment, then Multifunctional Database on the next screen. I leave the InnoDB settings unchanged. I select Manual Setting with 5 concurrent connections. I enable TCP/IP Networking on Port 3306 and Enable Strict Mode. I select the Standard Character Set. I check the boxes for Install as a Windows Service (and provide the name "MySQL") and Include the Bin Directory in Windows PATH. On the next screen, I set my root user name and password. I do not enable root access from remote machines and I also do not create an anonymous account.

On the final screen of the wizard, when I click "Execute", the first two tasks (Prepare Configuration and Write Configuration File) complete. However, when it reaches Start Service, the wizard hangs and becomes unresponsive ("Not Responding" appears in the title bar and Task Manager).

I would really like to be able to use both my Windows and Linux laptops as full-blown mobile development environments, but I can't do that without being able to run MySQL. Has anyone encountered this problem before? What options do I have to correct it?

Answer 1

i had this problem after un-installing and re-installing. during the MSI install, when it asks for the root password - check to see if it's asking for 'old password' in addition to a new one. If so, this is an indicator that there are old database files kicking around. I found my db-files in C:\ProgramData\MySQL. Uninstall MYSQL, nuke this directory (assuming you don't care about the database) and then re-install and you'll be good.

Answer 2

Try right-clicking on the msi and choosing "Run as Administrator". Remember that starting with windows Vista you don't run with administrator privileges by default, even if you're logged in to an administrator account. Instead, using an administrator level account merely gives you the ability to elevate particular processes when you need to.

Answer 3

The install crapped out on me as well. I closed the hung process and then went to START > All Programs >> MySQL >> MySQL Server 5.1

At this point, you should hold down the SHIFT key, and right-click on "MySQL Server Instance Config Wizard" and select "RUN AS ADMINISTRATOR" from the menu. You should be able to run through the entire setup again, and it should not hang at the end. "RUN AS ADMINISTRATOR" made all the difference!

Answer 4

For me, this problem seemed to be connected to the fact that I was trying several times to install MySQL and also changing the location of the database files. If you get the 1067 error in this situation

1. make sure the datadir option in my.ini points to your new database directory
2. make sure you've copied all files from the default directory to the new directory
3. delete any ibdata and ib_logfile files from the new directory.

=== Details ===

I was installing MySQL Server 5.5 on Win 7 and getting this problem - the MySQL Server Instance Configuration Wizard kept hanging on "Start service". I tried uninstalling and deleting all local MySQL files, and also running the wizard as administrator, but kept getting the same result.

The MySQL troubleshooting documentation gave some good clues. I eventually realised the problem was to do with me changing the location of the MySQL data files in the wizard from the default C:\Program Files\MySQL\MySQL Server 5.5\data to D:\MySQL Datafiles. MySQL has essential system files in that data directory - if it can't find them the service won't start.

• I opened the configuration file C:\Program Files\MySQL\MySQL Server 5.5\my.ini in notepad (running notepad as admin). I found the config wizard hadn't changed the datadir option, which was still pointing to the default folder. I changed it manually to the new address and saved the file.

• Tried starting the MySQL service manually, but go the same 1067 error.

• Realised none of the system files were in the new directory, so copied all files from C:\Program Files\MySQL\MySQL Server 5.5\data to the new location and tried restarting the MySQL service manually. Got the old error.

• When I looked in the new data files directory I found MySQL had created an .err log file there with these lines

InnoDB: No valid checkpoint found.

InnoDB: If this error appears when you are creating an InnoDB database,

InnoDB: the problem may be that during an earlier attempt you managed

InnoDB: to create the InnoDB data files, but log file creation failed.

InnoDB: If that is the case, please refer to

InnoDB: http://dev.mysql.com/doc/refman/5.5/en/error-creating-innodb.html

The page it referred to told me to delete any old ibdata and ib_logfile files from my data directory that were left over from previous installation attempts. As soon as I did this the service was able to start.

Answer 5

I had the same issue that the MySQL Server Instance Configuration hanged at Start Service. I tried used Run As Administrator option stiil had the same issue.

After removing ibdata and ib_logfile from datadir it started.

The error I had in .err file is below.

110616 10:32:35 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Error: log file .\ib_logfile0 is of different size 0 23068672 bytes
InnoDB: than specified in the .cnf file 0 25165824 bytes!
110616 10:32:35 [ERROR] Plugin 'InnoDB' init function returned error.
110616 10:32:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110616 10:32:35 [ERROR] Unknown/unsupported table type: INNODB
110616 10:32:35 [ERROR] Aborting

110616 10:32:35 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete

Answer 6

If you dont care about the existing databases then do what I did, it will surely work.

1. disable antivirus and make sure port 3306 is open (not blocked by windows/other firewall)
   This step is actually just for safety..
2. uninstall your current installation, remove the MySQL folder from C:\ProgramData.
   This folder will be hidden. So just type that path in the address bar to access it.
3. After removing C:\ProgramData\MySQL restart your computer.
4. Reinstall MySQL server and you wont have any problem.

The problem was due to file C:\ProgramData\MySQL\MySQL Server 5.5\data\ib_logfile0.file. because each time you uninstall and reinstall program, it appends the data to this file. It will result in larger file. Which will result in an error in InnoDB.

If you want you can remove that file only. But I wanted a clean reinstall, so I removed everything :-)

Answer 7

I've had this issue too a while ago. I didn't really solve the install, but I got it running afterwards. The configuration wizard is really just for configuration. The installation is already done at that point.

1. Check if the service is installed, if not, install it manually.
2. You can adjust your root password manually.

Maybe this can help:
http://remy.supertext.ch/2010/05/access-denied-for-user-rootlocalhost/

Let me know how it looks like, I'm sure we can get it running :-)

Answer 8

Kill the wizard and start MySQLInstanceConfig.exe again with "Run as Administrator"

Exe is location for most standard installs under C:\Program Files\MySQL\MySQL Server X.X\bin

Answer 9

Remove the MySQL Reference from c:\ProgramData As It keeps the reference for SQL DB. After removing this It allowed me to re-install mysql.