After running the windows installation script the MySql service would not start. It gave an error of 1067. I eventually removed the service using "mysqld --remove MySql" and manually reinstalled MySql. It is now starting.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
(btw: this might not be the fix you need. Apparently there are all sorts of thing that cause this particular problem, incl stuff as simple as installing mysql in a dir with a space in its path.)
This is the meat of the troubleshooting topic:
If you receive the following error message when you try to start MySQL service, you might need to create an option file under your Windows root:
Error: Could not start the MySQL service on Local Computer. Error 1067: The process terminated unexpectedly
To create an option file, create a new file and save as my.ini under your Windows root directory (type systemroot in the explorer to find out the location of your Windows root directory), and insert the following content:
[mysqld]
# set basedir to your installation path
basedir=E:/mysql
# set datadir to the location of your data directory
datadir=E:/mysql/data
Change basedir and datadir to their appropriate locations. basedir is the root directory of your MySQL installation, and datadir is the location where your database files reside (the default location is basedir/data).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I hate to be "that guy", but i suggest you refer this bug report to MySQL, or better Microsoft. Ok, Microsoft will ignore you, but MySQL might be able to workaround it so others aren't hit by this bug :)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
After running the windows installation script the MySql service would not start. It gave an error of 1067. I eventually removed the service using "mysqld --remove MySql" and manually reinstalled MySql. It is now starting.
This 1067 error seems to pop up a lot for people installing on windows. You can follow this link and look for the troubleshooting topic:
http://thecodecentral.com/2007/03/27/setting-up-your-own-web-server-with-apache-http-server-php-and-mysql-on-a-windows-machine-part-iii
(btw: this might not be the fix you need. Apparently there are all sorts of thing that cause this particular problem, incl stuff as simple as installing mysql in a dir with a space in its path.)
This is the meat of the troubleshooting topic:
If you receive the following error message when you try to start MySQL service, you might need to create an option file under your Windows root:
Error: Could not start the MySQL service on Local Computer. Error 1067: The process terminated unexpectedly
To create an option file, create a new file and save as my.ini under your Windows root directory (type systemroot in the explorer to find out the location of your Windows root directory), and insert the following content:
[mysqld]
# set basedir to your installation path
basedir=E:/mysql
# set datadir to the location of your data directory
datadir=E:/mysql/data
Change basedir and datadir to their appropriate locations. basedir is the root directory of your MySQL installation, and datadir is the location where your database files reside (the default location is basedir/data).
I hate to be "that guy", but i suggest you refer this bug report to MySQL, or better Microsoft. Ok, Microsoft will ignore you, but MySQL might be able to workaround it so others aren't hit by this bug :)