handbook, books, note, tutorial, troubleshooting

Solved: phpmyadmin #1698 - Access denied for user 'root'@'localhost'


Solved: phpmyadmin #1698 - Access denied for user 'root'@'localhost'

Mysql tries to authenticate root using plugin, not password. You need to disable plugin usage for root.

shell$ sudo mysql -u root

[mysql] use mysql;
[mysql] update user set plugin='' where User='root';
[mysql] flush privileges;
[mysql] \q





Solved: phpmyadmin #1698 - Access denied for user 'root'@'localhost'