mysql中mysql数据库丢失报错Can't open the mysql.plugin table

最新推荐文章于 2023-02-02 15:08:46 发布

转载最新推荐文章于 2023-02-02 15:08:46 发布 · 796 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/weizaiyes/p/11502544.html

文章标签：

#数据库 #开发工具

本文记录了一次MySQL启动时遇到的错误，包括无法打开mysql插件表、InnoDB初始化错误以及权限表无法打开等问题，并提供了初步的解决思路与步骤。

180720 10:00:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
180720 10:00:54  InnoDB: Initializing buffer pool, size = 8.0M
180720 10:00:54  InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242881 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
180720 10:00:54 [ERROR] Plugin 'InnoDB' init function returned error.
180720 10:00:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
180720 10:00:54 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host'

1.解决：mysql_install_db --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/

2.查看分析错误

vim /var/lib/mysql/instance-ggicik0l.err

转载于:https://www.cnblogs.com/weizaiyes/p/11502544.html