MySQL启动提示1067 错误的解决

2014-11-24 17:29:56 · 作者: · 浏览: 0

今天在重新安装MySQL服务的时候遇到如下错误:


C:\Program Files\MySQL\MySQL Server 4.1\bin>MySQLd-nt --remove
Service successfully removed.


C:\Program Files\MySQL\MySQL Server 4.1\bin>MySQLd-nt --install
Service successfully installed.


C:\Program Files\MySQL\MySQL Server 4.1\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.


发现一种最简单的方法:把MySQL目录下的my.ini copy到C:\WINDOWS中,再重新安装服务问题解决:


C:\Program Files\MySQL\MySQL Server 4.1>copy my.ini c:\WINDOWS\
1 file(s) copied.


C:\Program Files\MySQL\MySQL Server 4.1>MySQLd-nt --remove
Service successfully removed.


C:\Program Files\MySQL\MySQL Server 4.1>MySQLd-nt --install
Service successfully installed.


C:\Program Files\MySQL\MySQL Server 4.1>net start MySQL
The MySQL service is starting.
The MySQL service was started successfully.


网上有人给出了另外一个解决方法,比较麻烦,相信也是可行的:


把MySQL目录copy到c:\MySQL
copy my.ini到C:\WINDOWS目录
修改my.ini中basedir和datadir参数
重新install MySQL service


谁不嫌麻烦可以试一下。