Unable to login Phpmyadmin

Post Reply
shahidirfan
Posts: 11
Joined: Sat Sep 05, 2020 11:28 am

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';
User avatar
myVesta
Site Admin
Posts: 932
Joined: Fri Jun 19, 2020 9:59 am
Has thanked: 8 times
Been thanked: 6 times

The problem is how mysql root is implemented on Debian servers.
I looked https://www.google.com/search?q=debian+ ... root+login but I'm not sure what will help.
Post Reply