Fix MySQL version 5.6 function ' InnoDB ' already exists error

Fix MySQL version 5.6 function ' InnoDB ' already exists error CHSZS, reprint need to indicate. Blog home: Http://blog.csdn.net/chszs

After MySQL 5.6 is started, its log file has the following error:

......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‘.......

The reason for this analysis is that MySQL 5.6 does not have the following four plugins.

The MySQL 5.6 server initialization script adds the following plug-in tables, while in fact MySQL 5.6 does not depend on any plugins.

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)

To solve it is simple, execute the command:

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

Delete these 4 plugins, clear the log, restart the MySQL service, you can see that MySQL run without error.

Copyright NOTICE: This article for Bo Master Chszs original article, without Bo Master permission not reproduced.

Fix MySQL version 5.6 function ' InnoDB ' already exists error