mysql没有停止服务就修改了my.ini,后来重启报1067错误,不知道是不是因为没有停止mysql的原因。解决步骤如下:
1.进入my.ini的datadir 指向的目录,查看.err结尾的错误日志。
2.我的报
120827 14:08:19 [Note] Plugin
'FEDERATED'
is
disabled.
120827 14:08:19 InnoDB: The InnoDB memory heap
is
disabled
120827 14:08:19 InnoDB: Mutexes
and
rw_locks use Windows interlocked functions
120827 14:08:19 InnoDB: Compressed tables use zlib 1.2.3
120827 14:08:19 InnoDB: Initializing buffer pool,
size
= 4.0G
120827 14:08:20 InnoDB: Completed initialization
of
buffer pool
InnoDB: Error: log file .\ib_logfile0
is
of
different
size
0 56623104 bytes
InnoDB: than specified
in
the .cnf file 0 268435456 bytes!
于是上网找了找,将datadir指向目录下的ib_logfile0与b_logfile1两个文件删除就可以启动了。