Mysql 服务无法启动

Question

我在centos分布式和cPanel/WHM控制面板下的linux环境下运行mysql

我跟踪mysql日志，我得到了

130914  6:49:08 [Note] Plugin 'FEDERATED' is disabled.
130914  6:49:08 [ERROR] No paths allowed for shared library
130914  6:49:08 [Warning] Couldn't load plugin named '68' with soname 'افص�حات افإضا�ٍة فكلتدٍات اف�ٍ بٍ'.
130914  6:49:08 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/Cybernetec's Hacks Template Group' (errno: 0 cannot open shared object file: No such file or directory)
130914  6:49:08 [Warning] Couldn't load plugin named '487' with soname 'Cybernetec's Hacks Template Group'.
130914  6:49:08 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/Cyb - ChatBox - CT' (errno: 0 cannot open shared object file: No such file or directory)
130914  6:49:08 [Warning] Couldn't load plugin named '488' with soname 'Cyb - ChatBox - CT'.
130914  6:49:08 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/Cyb - ChatBox - IL' (errno: 0 cannot open shared object file: No such file or directory)
130914  6:49:08 [Warning] Couldn't load plugin named '489' with soname 'Cyb - ChatBox - IL'.
130914  6:49:08 [ERROR] Can't open shared library '/usr/lib64/mysql/plugin/[you]' (errno: 0 cannot open shared object file: No such file or directory)
130914  6:49:08 [Warning] Couldn't load plugin named '93' with soname '[you]'.
130914  6:49:08 [ERROR] No paths allowed for shared library
130914  6:49:08 [Warning] Couldn't load plugin named '117' with soname 'افإستبداف افآفٍ'.

我可以使用skip grant table选项启动mysql

/etc/init.d/mysql start --skip-grant-tables

Answer 1

问题是mysql数据库被其他表覆盖了

我删除了路径/var/lib/mysql/中的mysql文件夹

我通过运行命令删除了rpm mysql文件

# rpm -qa | grep -i mysql  > /mysql.txt

# for i in `cat /mysql.txt`;do rpm -e $i;done

然后我跑

/scripts/upcp

重新搭建mysql

我的 mysql 又启动并运行了