kloxo面板无法登陆如何修改mysql密码?

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

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

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

然后重启kloxo: Service kloxo ponovni zagon

演示过程如下

[[email protected]]# 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]
Zagon MySQL: [ v redu ]
Password successfully reset to “”

[[email protected]]# 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

[[email protected]]# service kloxo stop
Stopping kloxo: Waiting for the process to die…..
Stopped kloxo

[[email protected]]# ps -ef | grep mysql
root 40097 1 0 01:53 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safedatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.socklog-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.piduser=mysql
mysql 40151 40097 0 01:53 pts/0 00:00:00 /usr/libexec/mysqldbasedir=/usrdatadir=/var/lib/mysqluser=mysqlpid-file=/var/run/mysqld/mysqld.pidskip-external-lockingsocket=/var/lib/mysql/mysql.sock
root 40546 36123 0 01:54 pts/0 00:00:00 grep mysql
[[email protected]]# pkill mysql
[[email protected]]# ps -ef | grep mysql
root 40712 36123 0 01:54 pts/0 00:00:00 grep mysql
[[email protected]]# service kloxo start

Pustite komentar