PDA

View Full Version : Changing mySQL root password on the zPanel server



Fli
07-26-2014, 01:34 PM
If you change MySQl root password on the linux server with zPanel control panel, you may get error like:


Critical Error: [0100] - Unable to connect or authenticate to the ZPanel database (zpanel_core).
We advice that you contact the server administator to ensure that the database server is online and that the correct connection parameter are being used.
in your zpanel

this is because you need to tell zpanel new mysql root password. Change the password in these files:

vi /etc/zpanel/panel/cnf/db.php
vi /etc/zpanel/configs/proftpd/proftpd-mysql.conf

(just search old password and replace by new one)

How to change mysql root password?


mysqladmin -u root -pYourOldMysqlPassword password YourNewMysqlPassword

What is default zpanel mysql root password?

i think it was generated randomly, and its stored in /root/password/passwords.txt

amoozesh98com
12-14-2014, 05:10 AM
hi

plz help

im change zpanel mysql root passowrd does not connect ftp
change old root mysql password + cnf/db.php type old password

ftp ok ! login to ftp with filezilla !

:(
plz help plz help :((

amoozesh98com
12-14-2014, 06:18 AM
ok ! ok ! ok ! ok ! ok ! ok !

/etc/zpanel/configs/proftpd/proftpd-mysql.conf

type new password to this file &

/etc/init.d/proftpd restart



ok ok ok ok ok im hapy !
tnx