[Solved] Plugin ‘FEDERATED’ is disabled. /usr/sbin/mysqld: Table ‘mysql.plugin’ doesn’…

Problem: Plugin ‘FEDERATED’ is disabled when installing mysql on linux.
/usr/sbin/mysqld: Table ‘mysql.plugin’ doesn’t exist.

[root@hadoop11 mysql]# more hadoop11.err
160714 14:51:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160714 14:51:30 [Note] Plugin ‘FEDERATED’ is disabled.
/usr/sbin/mysqld: Table ‘mysql.plugin’ doesn’t exist
160714 14:51:30 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
160714 14:51:30 InnoDB: The InnoDB memory heap is disabled
160714 14:51:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160714 14:51:30 InnoDB: Compressed tables use zlib 1.2.3
160714 14:51:30 InnoDB: Using Linux native AIO
160714 14:51:30 InnoDB: Initializing buffer pool, size = 128.0M
160714 14:51:30 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:

Cause.
The reason why table ‘mysql.host’ does not exist is because after a new installation of the mysql service, it is generally necessary to perform database initialization operations , thus generating a table related to permissions, execute the following command.

/usr/bin/mysql_install_db –user=mysql

Note: The mysql_install_db in the above command is related to the location of your installed mysql service, if you don’t know where it is, you can use find/-name mysql_install_db to find its location, and then execute the above command.

[root@hadoop11 mysql]# find/-name mysql_install_db
/usr/bin/mysql_install_db

Similar Posts: