blog posts

有时候，在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.ctohome.com]# 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.ctohome.com]# service kloxo restart （重启kloxo，一般到这一步就OK了）

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

Starting kloxo: 11
Could not connect to Mysql server…
mysqld (pid 40151) is running…
Started kloxo

[root@www.ctohome.com]# service kloxo stop
Stopping kloxo: Waiting for the process to die…..
Stopped kloxo

[root@www.ctohome.com]# 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.ctohome.com]# service kloxo start