无论怎么安装Mysql,无论安装哪个版本的Mysql,启动Windows服务时都提示:
D:\mysql\bin>net start mysql
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.
Google了一下中文网站都没有收获,最后在Mysql的论坛上找到了解决方法,上面是这么说的:
Posted by: Michael Faraday
Date: February 19, 2005 04:57PM
I had the same problem on XP Professional. I solved it by specifying the defaults file path. If you already have a MySQL windows service named "MySql", first remove it with
mysqld --remove MySql
Then re-install the service with a defaults-file option as follows
mysqld --install <service name> --defaults-file=<full path of "my.ini" file>
For Eg: mysqld --install MySql --defaults-file=c:\mysql\my.ini
I hope it helps.
mysqld --remove MySql
Then re-install the service with a defaults-file option as follows
mysqld --install <service name> --defaults-file=<full path of "my.ini" file>
For Eg: mysqld --install MySql --defaults-file=c:\mysql\my.ini
I hope it helps.
My command:
D:\mysql\bin>mysqld --install MySql5 --defaults-file=D:\mysql\my-medium.ini
D:\mysql\bin>net start MySql5
一切OK!