0 votes
39.3k views
by (1.5k points)

I'm using PhpMyAdmin on XAMPP server. However, after installing WordPress on localhost, it start showing following error.

MariaDB Error
Welcome to phpMyAdmin

Error

  • MySQL said: Documentation
    Cannot connect: invalid settings.
  • mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server
  • Connection for controluser as defined in your configuration failed.
  • mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server
  • phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

1 Answer

0 votes
by (10.3k points)

Its commonly experienced error. It's due to crash of User table in MySQL database. The solution is simple. Just follow below step.

  1. Open XAMPP control panel
  2. Click MySQL > Config > my.ini
    XAMPP MySQL my.ini
  3.  Add below line under [mysqld] tag
    skip-grant-tables
    MySQL my.ini
  4. Save my.ini
  5. Restart MySQL server by pressing STOP and START button
  6. Now visit http://localhost/phpmyadmin/ or http://127.0.0.1/phpmyadmin/
  7. Select mysql DB
  8. Repair the table named user by selecting checkbox then click on Repair table
    MySQL Table Repair
  9. Done..! 

However, you can now remove the line skip-grant-tables added in my.ini under [mysqld] tag, if you want. Because it no more needed after successful implementation of 8th step. Hope, it could solve your error.

...