ERROR: phpMyAdmin Not Working in Vesta CP


After installing Vesta CP, whenever you try to access databases of your server via phpMyAdmin, you may get errors;


To fix this issue, follow these steps;

Login to server as a root via putty / IP address;

Change MySQL Root Password

sudo /etc/init.d/mysql stop

sudo mysqld_safe –skip-grant-tables &

mysql -uroot

use mysql;

update user set authentication_string=PASSWORD(“mynewpassword”) where User=’root’;

flush privileges;


sudo /etc/init.d/mysql stop

sudo /etc/init.d/mysql start

mysql -u root -p

Enter your newly created password.

Fix phpMyAdmin in VestaCP

curl -O -k && chmod +x && ./



Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s