Mysql start service 1067 解决

无论怎么安装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.

My command:

D:\mysql\bin>mysqld --install MySql5 --defaults-file=D:\mysql\my-medium.ini
D:\mysql\bin>net start MySql5

 

一切OK！

 

 

 

 

 

评论

1 楼 yiranlandtour 2011-04-07  

输入“D:\mysql\bin>mysqld --install MySql5 --defaults-file=D:\mysql\my-medium.ini”时出现以下错误：

110407 15:49:27 [ERROR] mysqld-nt: unknown option '--install'

PS：已将路径改为自己的路径