phpmyadmin - how recovery error (HY000/1698): Access denied for user 'root'@'localhost'

When I try login as a root user to my mariadb (mysql) database in phpmyadmin on my linux debian stretch, I got this error message:

mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@’localhost’

phpmyadmin error - mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@’localhost’

The problem is that a root access to mysql db with phpmyadmin as root is no longer supported. So, You must create another user with root privileges:

So, let’s go fix this problem:

mysql> CREATE USER newroot@localhost IDENTIFIED BY some_password;
mysql> GRANT ALL PRIVILEGES ON *.* TO newroot@localhost WITH GRANT OPTION;

Thats done :-)

Share Comments
comments powered by Disqus