飞来飞去博客|免费主机,国外主机,国外VPS,便宜VPS,便宜主机,免费资源。

有时候，在kloxo面板修改密码的时候，因为网络问题，意外中断，导致kloxo面板无法登陆，如何修改mysql密码？

ssh链接服务器 ，root登录，然后输入下面一行命令，回车，mysql的root密码将被重新设置为空。

php /usr/local/lxlabs/kloxo/bin/common/misc/reset-mysql-root-password.phps;

然后重启kloxo： service kloxo restart

演示过程如下：

[root@www.52pcbbs.cn]# php /usr/local/lxlabs/kloxo/bin/common/misc/reset-mysql-root-password.phps;
Stoping mysql
starting with skip grant tables
using mysql to flush privileges and reset password
Password reset succesfully. Now killing mysqld softly
sleeping
restarting the actual mysql service
Stopping MySQL:  [FAILED]
Starting MySQL:  [  OK  ]
Password successfully reset to ""

[root@www.52pcbbs.cn]# service kloxo restart  （重启kloxo，一般到这一步就OK了）

Stopping kloxo: Waiting for the process to die.....
Stopped kloxo

Starting kloxo: 11
Could not connect to Mysql server... <br> mysqld (pid 40151) is running...
Started kloxo

[root@www.52pcbbs.cn]# service kloxo stop
Stopping kloxo: Waiting for the process to die.....
Stopped kloxo

[root@www.52pcbbs.cn]# ps -ef | grep mysql
root     40097     1  0 01:53 pts/0    00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --user=mysql
mysql    40151 40097  0 01:53 pts/0    00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock
root     40546 36123  0 01:54 pts/0    00:00:00 grep mysql
[root@www.ctohome.com]# pkill mysql
[root@www.ctohome.com]# ps -ef | grep mysql
root     40712 36123  0 01:54 pts/0    00:00:00 grep mysql
[root@www.52pcbbs.cn]# service kloxo start