couldn't find mysql server_Starting MySQLCouldn't find MySQL manager or server

Starting MySQLCouldn't find MySQL manager or server 的解决方法 收藏

解决方法：mv /etc/my.cnf /etc/my.cnf.old

神经病问题    (问题产生 我把my.cnf修改后放到 新的虚拟机器，之后重启mysql发生这个问题 )

Starting MySQLCouldn't find MySQL manager or server解决方法

215 views, linux学习, by bluefox012.

#MYSQL从5.0升级至5.1.41安装日志

root@debain-server:/home/installfile/mysql-5.1.41# ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql --localstatedir=/home/services/mysql/data/var --sysconfdir=/home/services/mysql --enable-thread-safe-client --with-plugins=max

root@debain-server:/home/installfile/mysql-5.1.41#make&make install

root@debain-server:/usr/local/mysql# cp support-files/my-small.cnf /home/services/mysql/my.cnf

cd /home/services/mysql/

chown -R mysql:mysql mysql

root@debain-server:/usr/local/mysql# ./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql  --datadir=/home/services/mysql/data/var

Installing MySQL system tables...

091231 10:41:42 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--skip-bdb'

091231 10:41:42 [ERROR] Aborting

091231 10:41:42 [Warning] Forcing shutdown of 2 plugins

091231 10:41:42 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

#发现报错，尝试启动MYSql 发现启动报错。

root@debain-server:/usr/local/mysql#cp share/mysql/mysql.server /etc/init.d/mysqld

root@debain-server:/usr/local/mysql# /etc/init.d/mysqld start

Starting MySQLCouldn't find MySQL manager (/usr/bin/mysqlmanager) or server (/usr/bin/mysqld_safe) failed!

#查看日志文件

root@Craftsoft-server:/usr/local/mysql/bin# ./mysqld_safe

091231 10:48:17 mysqld_safe Logging to '/var/lib/mysql/Craftsoft-server.err'.

091231 10:48:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

091231 10:48:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

root@Craftsoft-server:/usr/local/mysql/bin# cat /var/lib/mysql/Craftsoft-server.err

091231  9:41:15 [Note]

091231 09:41:15 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

091231 09:41:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

091231  9:41:19 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'

/usr/local/mysql/libexec/mysqld: Unknown error 1146

091231  9:41:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

091231  9:41:19 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--skip-bdb'

091231  9:41:19 [ERROR] Aborting

原来还有一个配置文件在这里/etc/mysql/my.cnf

--skip-bdb前加#

再次重启还是错误

上网搜索，直接将/etc/mysql/my.cnf 重命名即可

root@Craftsoft-server:/etc/mysql# mv my.cnf my.cnf.old

root@Craftsoft-server:/etc/mysql# /etc/init.d/mysqld start

Starting MySQL..

综上所述，最重要的一步就是要将/etc/mysql/my.cnf 重命名

Tags: failed!, mysql, MySQL manager, skip-bdb

有人误导是basedir路径问题 需要把路径修改 我做了 发现是失败

网上东西不能全相信 必须亲自测试

作者: liyihongcug

发布时间: 2010-05-26