[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

用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。

本文轉自 xinsir999 51CTO部落格，原文連結：http://blog.51cto.com/xinsir/1704218，如需轉載請自行聯系原作者