解决mysql5.1启动问题的方法

找到my.ini文件中的如下代码段,注意其中后加进去的一句

#*** INNODB Specific options ***

innodb_data_home_dir&＃61;"D:/Data/"

# Use this option if you have a MySQL server with InnoDB support enabled

# but you do not plan to use it. This will save memory and disk space

# and speed up some things.

#skip-innodb//这里加一句&＃xff01;&＃xff01;&＃xff01;&＃xff01;&＃xff01;&＃xff01;&＃xff01;&＃xff01;&＃xff01;

# Additional memory pool that is used by InnoDB to store metadata

# information.  If InnoDB requires more memory for this purpose it will

# start to allocate it from the OS.  As this is fast enough on most

# recent operating systems, you normally do not need to change this

# value. SHOW INNODB STATUS will display the current amount used.

innodb_additional_mem_pool_size&＃61;2M

...

以上试过是好使的&＃xff0c;以下是解决问题过程中试过的方法&＃xff1a;

删除步骤应为下&＃xff1a;

&＃xff11;&＃xff0e;安装&＃xff0f;删除应用程序中卸载MYSQL程序

&＃xff12;&＃xff0e;命令模式下&＃xff1a;

net stop mysql

mysqld-nt -remove

&＃xff13;&＃xff0e;去删除所有的数据库文件&＃xff0e;删除WINDOW目录下的MY.INI文件

&＃xff14;&＃xff0e;进入注册表&＃xff0e;删除以下内容&＃xff1a;

A.HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL 目录删除

B.HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL 目录删除

C.HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL 目录删除

D.HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl001t\Services\MYSQL 目录

E.HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl002\Services\MYSQL　目录

F.HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MYSQL　目录

&＃xff10;&＃xff10;&＃xff11;&＃xff0e;&＃xff10;&＃xff10;&＃xff12;可能为其它值&＃xff0e;&＃xff0e;

&＃xff15;&＃xff0e;删除完以上内容后&＃xff0e;重装MYSQL&＃xff0e;成功了&＃xff01;&＃xff11;&＃xff10;&＃xff16;&＃xff17;错误也不会再出现了&＃xff01;&＃xff01;

总结一句话&＃xff0e;WINDOWS目录下的MY.INI是祸害的根源&＃xff0c;注册表中的EVENTLOG下的那些目录也是很需要注意的&＃xff0c;但没有前者重要&＃xff01;