MySQL Service won't start on Windows 7
Posted on Tue 12 July 2011 in blog
So today, I attempted to install MySQL on Windows 7. From the MySQL Download
site, I grabbed the latest version
of their .msi
installer, mysql-installer-5.5.13.2.msi
. I went through the
installer, and found that the last step, starting the MySQL services (mysqld
)
was failing. The service existed in services.msc
, and in the registry, but
it refused to start. Attempting to start it from the command line (NET START
MySQL
) failed, giving the following output:
The MySQL service is starting...
The MySQL service could not be started.
A system error has occurred.
System error 1067 has occurred.
The process terminated unexpectedly.
Very descriptive. Thanks. I tried checking for a log file from MySQL, but
could't find it. Strange. Well, it turns out, MySQL on windows has its data
directory at C:\ProgramData\MySQL\MySQL Server 5.5\data
. You can verify this
in your installation by looking at the my.ini
file, in your MySQL
installation directory (probably C:\Program Files (x86)\MySQL\MySQL Server
5.5\
), and finding the line that says datadir=
I didn't even know ProgramData existed! It's hidden, so either unhide it
(Control Panel -> Folder Options -> Show hidden...) or simply enter
c:\ProgramData
into your explorer title bar. In this data directory, there
should exist the log file [hostname].err
. Taking a glance at that, I found:
InnoDB: Error: log file .\ib_logfile0 is of different size 0 33554432 bytes
InnoDB: than specified in the .cnf file 0 56623104 bytes!
Thanks to this post on forums.mysql.com,
I found that simply deleting ib_logfile0
and ib_logfile1
solved the problem.
Seems like a dumb installer mistake to me! A bug report
already exists, so I'll just keep quiet until the next install :-) Hope this
helps!