CODEWITHSUNDEEP
phpphpmyadminxampp
Mai Ahmad
Mai Ahmad

Reputation: 41

Host 'localhost' is not allowed to connect to this MariaDB server

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

Upvotes: 3

Views: 24156

Answers (2)

atymic
atymic

Reputation: 3128

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:

GRANT ALL PRIVILEGES ON *.* TO '<username>'@'localhost';

Upvotes: 1

Naveen
Naveen

Reputation: 91

If you are using xampp, then simply add skip-grant-tables below of [mysqld] and above of port= 3306 in C:\xampp71\mysql\bin\my.ini file.

Note: am using xampp with php7.1 and mariadb 10.3.16

Upvotes: 9

Related Questions