centos mysql 问题：Plugin &＃39;FEDERATED&＃39; is disabled. /usr/sbin/mysqld: Table &＃39;mysql.plugin&＃39; doesn&＃39;t exist

早上看到服务器mysql挂掉了。于是重启mysql,启动失败:

/usr/bin/mysqld_safe: line 183: 23638 Killed &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160;nohup /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock /dev/null 2>&1
MySQL Daemon failed to start.
Starting mysqld: &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; &＃160; [FAILED]

&＃160;

&＃160;

&＃160;

解决:

vim /etc/my.cnf

[root@YoujiePMP ~]# vim /etc/my.cnf

加入配置:

key_buffer=16K
table_open_cache=4
query_cache_limit=256K
query_cache_size=4M
max_allowed_packet=1M
sort_buffer_size=64K
read_buffer_size=256K
thread_stack=64K
innodb_buffer_pool_size = 56M

&＃160;

&＃160;

&＃160;

保存。重启mysql

service mysqld restart

解决之。