Hi,
I am unable to login to PHPMyAdmin via root user. It gives this error.
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
Even I got the password from this location but failed to login.
nano /usr/local/vesta/conf/mysql.conf
In ubuntu 18.04 solved this problem by updating password via this command
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pWKQiSdwMBZDJfWZEnxgEHCPl4GgkJ';