skip to Main Content

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


  1. 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;
    
    Login or Signup to reply.
  2. 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

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search