A PHP Error was encountered
Severity: Warning
Message: mysqli::real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server
Filename: mysqli/mysqli_driver.php
Line Number: 203
A Database Error Occurred
Unable to connect to your database server using the provided settings.
Filename: C:/xampp/htdocs/himel-web/system/database/DB_driver.php
Line Number: 436
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
The connection for the controller 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.
Solution:
It's a commonly experienced error. It's due to a crash of the User table in the MySQL database. The solution is simple. Just follow the below step.
1. Open the XAMPP control panel
2. Click MySQL > Config > my.ini
3. Add the below line under [mysqld] tag
skip-grant-tables
4. Save my.ini
5. Restart the MySQL server by pressing the STOP and START button
6. Now visit http://localhost/phpmyadmin/ or http://127.0.0.1/phpmyadmin/