[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
来源:互联网 发布:域名管理平台 编辑:程序博客网 时间:2024/04/28 03:11
用Percona XtraBackup的备份在slave上进行恢复的时候遇到下述错误:
Master 版本:5.6.17
Slave 版本:5.6.21-enterprise-commercial-advanced-log
mysqld_safe mysqld from pid file /data/UAT-mysql02.pid ended
mysqld_safe Starting mysqld daemon with databases from /data
2014-11-10 18:03:34 7603 [Note] Plugin 'FEDERATED' is disabled.
/bin/mysqld: Table 'mysql.plugin' doesn't exist
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
[Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
[ERROR] InnoDB: space header page consists of zero bytes in data file /data/ibdata1
[ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the s
ystem tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ib
data files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way.
But be careful: do not remove old data files which contain your precious data!
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] Aborting
网上大多数的解决办法是在运行初始化权限表的时候使用增加参数--datadir ,命令格式为:
shell> scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/var
但这种方法并不适用。
检查my.cnf 看到 read_only= on ,注释掉,重新启动mysql,ok。
- [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
- Mysql :Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
- Can't open the mysql.plugin table. Please run mysql_upgrade to create it
- mysql启动不了,报错“[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it”
- Can't open the mysql.plugin table. Please run mysql
- Can't open the mysql.plugin table. Please run mysql
- MYSQL启动错误Can't open the mysql.plugin table
- 160409 11:06:06 [ERROR] Can't open the mysql.plugin table.
- 解决mysql启动错误:Fatal error: mysql.user table is damaged. Please run mysql_upgrade.
- mysql运行时报错,“Can't open the mysql.plugin table”
- mac os mysql启动报错 Can't open the mysql.plugin table
- MySQL安装好后无法运行(Can't open the mysql.plugin table)
- Can't Change to Run as User 'Mysql'. Please Check That the User Exists!
- Can't change to run as user 'mysql' Please check that the user exists
- mysql ERROR: Error 1005: Can't create table (errno: 121)
- mysql 创建外键:ERROR 1005: Can't create table
- mysql 创建外键:ERROR 1005: Can't create table
- MySQL ERROR 1005: Can't create table (errno: 150)解决办法
- php缓存技术
- HTTP 头参考
- struts2的标签generator生成的IteratorGenerator类型转换为ArrayList的方法
- ArcGIS表关联方式介绍(一)-Join、Relate 支持
- <转>android-滑动菜单栏-开源项目SlidingMenu的搭建和使用
- [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
- 增量索引构建
- 线段树区间合并+最长连续递增子序列——HDU 3308
- Failed to Find Android Wearable Dependency的解决办法
- mysql常见优化
- 程序开发的牛顿三大定律
- JPA注解
- eclipse—调试快捷键
- Linux Netstat命令详解及实例