有时候,在kloxo面板修改密码的时候,因为网络问题,意外中断,导致kloxo面板无法登陆,如何修改mysql密码?
ssh链接服务器,root登录,然后输入下面一行命令,回车,mysql的root密码将被重新设置为空。
php /usr/local/lxlabs/kloxo/bin/common/misc/reset-mysql-root-password.phps;
然后重启kloxo: service kloxo restart
演示过程如下:
[[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]
Starting MySQL: [ OK ]
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... <br> 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_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
[[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