Solve VestaCP Error: connection to localhost failed

Some SEO professionals have installed VestaCP :

• He added 2 databases and 2 sites.
• Everything looks business as usual today.

Error problem with VestaCP

But today when he tried to add the third database, he received the error message: "Error: connection to localhost failed "...

he tries to change/usr/local/vesta/conf/mysql.conf password in the file.

• Existing database is not running, still cannot add new database.

When restarting the server, you may encounter the following error: Error: connection to localhost failed, connection to VestaCP failed...

An administrator of an e-commerce website set up a MySQL database , but encountered the same error when trying to connect to the website :

• After doing some research, noticed that the password value was in/root/.my.cnfThere is no change in.
• But when/usr/local/vesta/conf/mysql.confThe correct password is displayed, and the content submitted through the panel is sufficient.

Solution

1) Change the password in the MySQL default file ▼

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

• Change the previous password to your existing password.

2) Restart the MySQL database ▼

service mariadb restart

• Or log in to VestaCP Panel → Server → Restart MySQL.

Extended reading:

🔗VestaCP official website may not have installation and configuration Chinese tutorials

🔗Optimize VestaCP phpfcgid template configuration process and multiple memory exhaustion 500 errors

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

🔗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