解決MySQL 5.6版的Function 'innodb' already exists錯誤

標籤：mysql   function   innodb   already   exists   

解決MySQL 5.6版的Function ‘innodb’ already exists錯誤chszs，轉載需註明。部落客頁：http://blog.csdn.net/chszs

MySQL 5.6啟動後，其記錄檔存在如下錯誤：

......2015-10-28 13:27:05 25054 [ERROR] Function ‘innodb‘ already exists2015-10-28 13:27:05 25054 [Warning] Couldn‘t load plugin named ‘innodb‘ with soname ‘ha_innodb.so‘.2015-10-28 13:27:05 25054 [ERROR] Function ‘federated‘ already exists2015-10-28 13:27:05 25054 [Warning] Couldn‘t load plugin named ‘federated‘ with soname ‘ha_federated.so‘.2015-10-28 13:27:05 25054 [ERROR] Function ‘blackhole‘ already exists2015-10-28 13:27:05 25054 [Warning] Couldn‘t load plugin named ‘blackhole‘ with soname ‘ha_blackhole.so‘.2015-10-28 13:27:05 25054 [ERROR] Function ‘archive‘ already exists2015-10-28 13:27:05 25054 [Warning] Couldn‘t load plugin named ‘archive‘ with soname ‘ha_archive.so‘.......

分析原因，是MySQL 5.6沒有以下四個外掛程式所致。

MySQL 5.6伺服器初始化指令碼添加了以下的外掛程式表，而實際上MySQL 5.6不依賴於任何外掛程式。

mysql> select * from mysql.plugin;+-----------+-----------------+| name      | dl              |+-----------+-----------------+| innodb    | ha_innodb.so    || federated | ha_federated.so || blackhole | ha_blackhole.so || archive   | ha_archive.so   |+-----------+-----------------+4 rows in set (0.00 sec)

解決它很簡單，執行命令：

mysql> delete from mysql.plugin;Query OK, 4 rows affected (0.00 sec)

刪掉這4個外掛程式，清除日誌，重啟MySQL服務，可以看到，MySQL無錯運行。

著作權聲明：本文為博主chszs的原創文章，未經博主允許不得轉載。

解決MySQL 5.6版的Function 'innodb' already exists錯誤