解决:mysql错误 1067

解决:mysql错误1067

修改了windows下mysql的my.ini缓存配置后发现mysql无法重启，在cmd下运行net start mysql提示错误如下:51Testing软件测试网%uV5J2X3P
a-Jw

A system error has occurred.51Testing软件测试网u:W!HKp({p4^
System error 1067 has occurred.51Testing软件测试网 ti&w7UZ.E
The process terminated unexpectedly.51Testing软件测试网t6v"M4a(P&U

解决方式如下：51Testing软件测试网
He+wVgOOu#m eG

一．打开mysql安装目录下的my.ini，找到配置database的安装目录的部分，确认是否路径存在且有效

#Path to the database root

datadir="C:/mysql/data"

(如果没有，则手动创建一个51Testing软件测试网o}rn*[ _$u

[mysqld]51Testing软件测试网 Veq)ct(@0t+k+v g
# set basedir to installation path, e.g., c:/mysql
&Y9C2H zCN T7URe0#设置为MYSQL的安装目录
k R;sz&?
X ~0basedir= “C:/mysql”51Testing软件测试网K%EW:t,e^ P
# set datadir to location of data directory, 51Testing软件测试网q/G^v
}4B
#设置为MYSQL的数据目录51Testing软件测试网3u@5c3Qr^kNw
datadir="C:/mysql/data")51Testing软件测试网}o2`1w~ ~z9U,i7s%a

 51Testing软件测试网%a},I?oo

二．然后打开C:/mysql/data，删除临时文件

ib_logfile0、ib_logfile1、ibdata1以及XX X.err

 51Testing软件测试网3hEwC
i

然后在cmd下重新运行net start mysql51Testing软件测试网&g|%FFUkz

提示成功51Testing软件测试网#EQqm,Jc

The MySQL service is starting.51Testing软件测试网B gG&D~9{q

The MySQL service was started successfully.51Testing软件测试网 T6wkfQzc