Fix: Could not start the MySQL service: Error 1067
Now this solution I assume is only good for initial installs, not upgrades. You could try it, but at least this gives you some direction in where to look.
Now for whatever reason, you stopped the service and one thing led to another. Now you can't start it back up. No problem, just backtrack yourself.
Ok, some quick troubleshooting and I found a fix for all those with WINXP/NT systems installing the MySQL 5. During installation it wanted to start a database and do the root password, and make a service, remember? Well, it listed many different service instance names too. That's not going to matter as what you are going to do REMOVE all instances of the service.
Now go through the steps ONE more time in creating a service instance using all the same password and location info. You do this because you want at least one instance to start the service properly. If you run it after the next steps, you've gone and created another file and renamed the original. If for some reason, you changed the password in another instance, use the new password as the database will have changed to reflect that.
When you run the instance program, it WILL fail. This is supposed to happen.
Now we're going to do some file checking.
You also remember where you put the database at right?
x being your location.
x:\MySQL Datafiles is what it is called. It is mentioned in your install directory under:
innodb_data_home_dir="x:/MySQL Datafiles/"
You could go through the incredible heartache of reinstalling everything after wiping it all... oooooorrrrr you can go to your program install directory. Something usually like C:\Program Files\MySQL\MySQL Server 5.0
or a different drive if you're actually using the system as a web server. But for all the development people, that is where you most likely installed it.
Find the file that says my.ini
You might also be seeing other files like:
my 2006-01-22 2004.ini
Those are the replaced ini files after you tried to recreate instances. once the service wouldn't start. Open the others up in a text editor and look for where your database is installed. Usually the earliest dated copy is it. Remove the other files along with the regular my.ini file and rename my 2006-01-22 2004.ini (Could be named a different date) to my.ini You may also change the location of your database if that's what happened. The my.ini is simply a pointer.
Now once the old files are removed and you have the ini file you want re-named to my.ini, go into the services and manually start MYSQL. It should start.
Hope this helps.
-John
Subject
Written By
Posted
February 13, 2005 11:22PM
February 15, 2005 11:28AM
February 15, 2005 02:33PM
February 19, 2005 04:57PM
February 15, 2008 09:38PM
February 18, 2009 01:47PM
February 14, 2008 07:37AM
November 03, 2007 07:08AM
December 13, 2007 11:32PM
December 06, 2005 05:02PM
Fix: Could not start the MySQL service: Error 1067
January 24, 2006 04:39PM
September 11, 2007 07:13AM
February 20, 2007 11:08AM
December 05, 2007 03:38PM
December 14, 2007 01:55PM
December 14, 2007 01:48PM
February 04, 2008 03:12AM
February 28, 2008 10:34PM
December 12, 2008 03:23AM
December 05, 2008 05:32PM
February 04, 2009 04:47AM
November 20, 2007 02:21PM
November 19, 2007 11:39AM