mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server

Question

I'm using PhpMyAdmin on XAMPP server. However, after installing WordPress on localhost, it start showing following 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.

Answer 1

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
   
3.  Add below line under [mysqld] tag
   skip-grant-tables
   
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
   
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 8^th step. Hope, it could solve your error.