找到my.ini文件中的如下代码段,注意其中后加进去的一句 #*** INNODB Specific options *** innodb_data_home_dir="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//这里加一句!!!!!!!!! # 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=2M ... 以上试过是好使的,以下是解决问题过程中试过的方法: 删除步骤应为下: 1.安装/删除应用程序中卸载MYSQL程序 2.命令模式下: net stop mysql mysqld-nt -remove 3.去删除所有的数据库文件.删除WINDOW目录下的MY.INI文件 4.进入注册表.删除以下内容: 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 目录 001.002可能为其它值.. 5.删除完以上内容后.重装MYSQL.成功了!1067错误也不会再出现了!! 总结一句话.WINDOWS目录下的MY.INI是祸害的根源,注册表中的EVENTLOG下的那些目录也是很需要注意的,但没有前者重要!
mysql5.1启动不了_mysql-5.1.30重装启动不了的解决
最新推荐文章于 2021-02-07 22:53:56 发布