Glasnhost

Asked: 2015-01-28 10:09:29 +0800 CST2015-01-28 10:09:29 +0800 CST 2015-01-28 10:09:29 +0800 CST

Mysql守护进程启动失败：未知变量密码=xxx

772

mysqld 不再重新启动...在日志中，明显的原因是：

mysqld started
[Warning] Ignoring user change to 'root' because the user was set to 'mysql' earlier on the command line
[ERROR] /usr/libexec/mysqld: unknown variable 'password=mypassword'
mysqld ended

/etc/my.cnf 没有什么相关的，也没有这样的变量，顺便说一下，消息中有正确的 mysql root 密码值（！！！？）：

[mysqld]
user=mysql
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysqld_safe] 
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Centos 5.9 上的 Mysql 5.0.95。重启前一切正常！！

也试过

 /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --no-defaults
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld ended

2 个回答

Voted

Best Answer

Glasnhost
2015-01-28T10:27:59+08:002015-01-28T10:27:59+08:00
我在这里遵循了最后一个建议

cd /usr ./mysqld_safe --defaults-file=/etc/my.cnf --user=mysql --ledir=/usr/libexec &

现在它开始了，但不明白它......不是很好！
0
Tomasz Syc
2016-01-19T07:59:37+08:002016-01-19T07:59:37+08:00
我有同样的问题。刚刚从 /etc/my.conf 中删除了密码行并启动了 mysqld 不知道那是什么...
-1

Web Analytics