kloxo panel could not land，How to modify the mysql password?
sometimes，In kloxo panel to change the password when，Because of network problems，Unplanned outages，Cause kloxo panel could not land，How to modify the mysql password?
ssh server links，root login，Then enter the following command line，Enter，mysql root password will be reset to empty。
php /usr/local/lxlabs/kloxo/bin/common/misc/reset-mysql-root-password.phps;
Then restart kloxo： kloxo service restart
Demo process is as follows：
[[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]]# kloxo service restart (重启 kloxo，Usually this step is 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]]# kloxo stop service
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]]# kloxo service start
