02 October 2019

ปัญหา 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
    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 wantBecause it no more needed after successful implementation of 8th step. Hope, it could solve your error.

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

er

No comments:

Post a Comment