mysql启动失败1067

今天启动Mysql时碰到了 1067 错误，奇怪得很，都用了一年多了好好的。上网一查，可能跟my.ini文件有关系
打开文件一看，靠，不知道怎么回事，少了最重要的两行
[mysqld]
basedir=E:/Program Files/mysql         #修改成你的sql安装目录
datadir=E:/Program Files/mysql/data    #修改成你的sql数据目录
把它加上去就ok了

如果还是没有解决问题，下面有几个我从网上收集的相关建议

1、找官方寻求帮助
From MySQL manual:

A system error has ocurred.
System Error 1067 has ocurred.
The process was terminated unexpectedly.

These errors mean that your option file (by default `C:/my.cnf') contains an option that cannot be recognized by MySQL. You can verify that this is the case by trying to restart MySQL with the option file renamed to prevent the server from using it. (For example, rename `C:/my.cnf' to `C:/my_cnf.old'.) Once you have verified it, you need to identify which option is the culprit. Create a new `my.cnf' file and move parts of the old file to it (restarting the server after you move each part) until you determine which option causes server startup to fail.

2、windows用户的习惯性动作---重装
yes it would be better to reinstall mysql :
- kill the mysqld-nt.exe process with the task manager if it exists.
- delete the directory c:/mysql and all subdirectories
- delete c:/windows/my.ini
- reinstall mysql, preferably stable version (4.0.20)
- run c:/mysql/bin/winmysqladmin.exe it will ask you a user and a password. enter whatever you want it will not be used
- you should have an icon in the system tray, right click, Winnt / Install the service and net start mysql
- add c:/mysql/bin to your path
- try to log to mysql using : mysql -u root

3、这位同学比较爱钻研，他建议去看错误日志。我看了，不太懂
Hi. You should check the error messages Mysql stored in it's .err file. This file is either /mysql/data/mysql.err or /mysql/data/name.err (where "name" is your machine's name).
I once had this problem and it was a wrong size in innodb logs. I just deleted the logs and mysql started to work again (I could do that 'cos I didn't care for the data...)