首页 > 数据库技术 > 详细

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

时间:2019-09-10 21:20:51      阅读:175      评论:0      收藏:0      [点我收藏+]
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

  

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

原文:https://www.cnblogs.com/weizaiyes/p/11502544.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!