Forgot the default root password of VestaCP MySQL?Set and modify the root password

Among the many control panels available, many SEO professionals prefer to use the Vesta CP control panel when purchasing a VPS for website building .

• because VestaCP Control panel, basically all configuration files are stored in conf files.
• LinuxDuring the process of installing VestaCP on the system, VestaCP will not ask for inputMySQLroot password.
• The password is automatically generated by VestaCP.

How can we find and change the default password for MySQL when logging into phpMyAdmin ?

The MySQL default password for VestaCP exists in /usr/local/vesta/conf/mysql.conf in the file.

SSH to view MySQL default password

You can enter the following command in SSH to view the default root password of MySQL ▼

cat /usr/local/vesta/conf/mysql.conf

Find the MySQL password, and record the location of the MySQL password file, you can log in to phpMyAdmin database management.

How to change the root password of MySQL?

Please see the following method for changing the MySQL root password in VestaCP CentOS .

Step 1: Log in to MySQL and enter the following command ▼

mysql -uroot -p

• Enter the MySQL root password you viewed in step 1.
• After successful login, make the modification.

Step 2: Change the MySQL password

set password for root@localhost = password('新密码');

Step 3: While logged into MySQL, refresh privileges.

mysql> flush privileges;

How to change root password without logging in to MySQL

mysqladmin -uroot -p旧密码 password 新密码

After modifying the root password with the above method, you must modify the password in the MySQL default file ▼

vi /usr/local/vesta/conf/mysql.conf

• Change the previous password to your existing password.

If the password in the default MySQL file is not changed, the error message "VestaCP Error: connection to localhost failed" will appear...

For the solution, please refer to this tutorial▼

🔗Solve VestaCP Error: connection to localhost failed

Extended reading:

🔗Is the HTTPS port 8083 of VestaCP backend invalid? Tutorial on installing SSL certificate

🔗How to use VestaCP panel? Install post office/add multiple domain names & file management