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;
mysql> FLUSH PRIVILEGES;
Thats done :-)
