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

Among the many control panels, manySEOPeople buy VPSBuilding website, prefer to use the Vesta CP control panel.

• 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.

we are logging inphpMyAdmin, how to find and modifyMySQL the default password?

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 VestaCP CentOS How to change the MySQL root password.

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 MySQL password 

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

Step 3:In the state of logging in to MySQL, refresh the permissions

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 MySQL default file is not modified, "VestaCP Error: connection to localhost failed" error message...

For the solution, please refer to this tutorial▼

Solve VestaCP Error: connection to localhost failed

Some SEO guy installed VestaCP: he added 2 databases and 2 sites.Everything looks business as usual today. VestaCP had an error problem but today when he tried to add a 3rd database he got the error: "Error: connecti...

Extended reading:

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...