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

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:

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 🙂

Pin It on Pinterest