How to Solve MYSQL Error: Plugin ‘FEDERATED’ is disabled. /usr/sbin/mysqld: Table ‘mysql.plugin’…

After installing MySQL today, an error occurred when opening it:

1. Open the corresponding folder to view the error message:

2. Open the error information file and check that the error reason is: plug in ‘federated’ is disabled./usr/SBIN/mysqld: table ‘mysql. Plugin’ doesn’t exist

3. The reason why ‘mysql. Plugin’ does not exist is that after the newly installed MySQL service, it is generally necessary to perform database initialization operation to generate permission related tables. The execution command is as follows:

/usr/bin/mysql_install_db --user=mysql

4. If the command is executed successfully, it is best. If the following error is reported:

The solution is to install the Autoconf library

yum -y install autoconf

5. Then execute the database open command, it will succeed

service mysql start

Tip: it’s better to install the database in usr/local/because many things by default point to this folder

Similar Posts: