kloxo面板无法登陆，如何修改mysql密码？
有时候，在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.xxx.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.xxx.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… <br> mysqld (pid 40151) is running…
Started kloxo
[root@www.xxx.com]# service kloxo stop
Stopping kloxo: Waiting for the process to die…..
Stopped kloxo
[root@www.xxx.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.xxx.com]# pkill mysql
[root@www.xxx.com]# ps -ef | grep mysql
root 40712 36123 0 01:54 pts/0 00:00:00 grep mysql
[root@www.xxx.com]# service kloxo start
目录 返回
首页