I got the below error message when login in PhpMyAdmin even from the terminal:
mysqli_real_connect(): (HY000/1130): Host ‘localhost’ is not allowed
to connect to this MariaDB server
This solution does not work :
[mysql]
skip-grant-tables
I use Xampp on windows10
2
Answers
That error means that the user you are trying to use when authenticating with mysql doesn’t have permission.
You can fix this by making sure the user has the widest permissions:
If you are using xampp, then simply add
skip-grant-tables
below of [mysqld] and above of port= 3306 in C:xampp71mysqlbinmy.ini file.
Note: am using xampp with php7.1 and mariadb 10.3.16