重装mysql无法启动服务的问题
发布时间：2022-06-18 08:52:44 所属栏目：MySql教程 来源：互联网
导读：今天由于一些原因需要把mysql删除了然后重新安装,但是重新安装mysql之后无法重启了,下面我把我的解决办法分享给各位同学,希望对大家有所帮助. Linux下mysql重装后无法重启解决办法 之前装的mysql5.1,但是经过系统还原后服务没有了,干脆升级到5.5,但是安装好
|
今天由于一些原因需要把mysql删除了然后重新安装,但是重新安装mysql之后无法重启了,下面我把我的解决办法分享给各位同学,希望对大家有所帮助. Linux下mysql重装后无法重启解决办法 之前装的mysql5.1,但是经过系统还原后服务没有了,干脆升级到5.5,但是安装好了,配置时最后一步就是启动不了. 查看日志:programdata/data/pc.err发现: 111121 22:16:50 InnoDB: Log file .ib_logfile0 did not exist: new to be created InnoDB: Setting log file .ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait… 111121 22:16:50 InnoDB: Log file .ib_logfile1 did not exist: new to be created InnoDB: Setting log file .ib_logfile1 size to 10 MB InnoDB: Database physically writes the file full: wait… 111121 22:16:50 InnoDB: Cannot initialize created log files because 111121 22:16:50 InnoDB: data files are corrupt, or new data files were 111121 22:16:50 InnoDB: created when the database was started previous 111121 22:16:50 InnoDB: time but the database was not shut down 111121 22:16:50 InnoDB: normally after that. 111121 22:16:50 [ERROR] Plugin ‘InnoDB’ init function returned error. 111121 22:16:50 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. 111121 22:16:50 [ERROR] Unknown/unsupported storage engine: INNODB --phpfensi.com 111121 22:16:50 [ERROR] Aborting 在网上一查,原来要将ib_logfile0,ib_logfile1,还有ibdata1这三个文件删掉才行,它们分别在data和programdata目录中(在配置时由你指定的). windows下mysql重装后无法重启解决办法 解决方法: 1: 先卸载mysql,手动将其安装目录里没有删除干净的文件全部删除. 2: 将C:/ProgramData/MySQL 里有关mqsql的文件全部删除. 3: 重新安装 mysql 程序. mysql服务就可以正常启动了. （编辑：周口站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
