ปัญหา XAMPP Error mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server

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

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.

--------------------------------------------------------------------------------------------------------------------

credit : https://doubtsolver.com/ask/739/mysqli_real_connect-localhost-allowed-connect-mariadb-server

---------------------------------------------------------------------------------------------------------------------

er