mysqli_real_connect(): (HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server
- Open XAMPP control panel
- Click MySQL > Config > my.ini
- Add below line under [mysqld] tag
skip-grant-tables - Save my.ini
- Restart MySQL server by pressing STOP and START button
- Now visit http://localhost/phpmyadmin/ or http://127.0.0.1/phpmyadmin/
- Select mysql DB
- Repair the table named user by selecting checkbox then click on Repair table
- 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.
--------------------------------------------------------------------------------------------------------------------
credit : https://doubtsolver.com/ask/739/mysqli_real_connect-localhost-allowed-connect-mariadb-server
---------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment