Solve VestaCP Error: connection to localhost failed

will get SEOpeople installedVestaCP :

• 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 3rd database, he got the error:"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, this error may appear:Error: connection to localhost failed, connection failed on VestaCP...

certainE-commerceThe site administrator has setMySQL database, but when you want to connect the site,Stumbled upon the same error:

• 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) ModifyMySQLPassword in 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:

Installation and configuration Chinese tutorials that may not be available on the official website of VestaCP

VestaCP is a Linux hosting control panel that is quick to install, simple to use, and full of features.Due to the wide range of supported operating systems, VestaCP panels are also very popular among SEOs and ecommerce webmasters. The tutorials on VestaCP's official website are a bit confusing and can't...

Optimizing VestaCP phpfcgid template configuration process multi-memory exhaustion 500 errors

After VestaCP's WEB service selects the "phpfcgid" template, a large number of PHP-CGI processes cause the memory to be quickly exhausted: within a few hours of restarting the server, it is basically in a state of insufficient memory.The previously idle PHP-CGI process was not...

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

Among the many control panels, many SEOs prefer to use the Vesta CP control panel when purchasing a VPS to build a website.Because of the VestaCP control panel, basically all configuration files are stored in the conf file. In the process of installing VestaCP on Linux system...

VestaCP background 8083 port https is invalid?Install SSL Certificate Tutorial

The VestaCP control panel is simple and easy to use: installing the VestaCP control panel can automatically install the security function of the Let's Encrypt SSL certificate, so it is very popular among foreign SEO practitioners.What is Let's Encrypt? Let's Encrypt is an S...

How to use VestaCP panel?Install Post Office/Add Multiple Domains & File Management

VestaCP is a very simple, yet powerful and efficient Linux web hosting control panel.By default, it will install nginx web server, PHP, Mysql, DNS server and other software that must run a full web server, which are all SEO...