SQLSTATE [HY000] [1130] Host ‘localhost’ is not allowed to connect to this MariaDB server

I’m using windows 11 and  PhpMyAdmin on the XAMPP server. Once while working, the MySQL server  and PHPMyAdmin stop working with this error:

Solution:

It’s due to a crash of the User table in the MySQL database. The solution is straightforward. Just go through the following steps:

  • Open XAMPP control panel
  • Click MySQL > Config > my.ini

Add below line under [mysqld] tag. if the [mysqld] tag not exists then you can create a new one.
skip-grant-tables

Save my.ini

Restart MySQL server by pressing the STOP and START button

Related Posts

Unable to upload database with phpMyAdmin: Script timeout passed

In this article we have shown How to fix the “Script timeout passed, if you want to finish import, please resubmit the same file and import will…

How to PHP Project Run On a Local Server

This is my PHP project First of Go to your Xampp/apache/conf/extra file and open httpd-vhosts.conf the all file comment Then you can run your PHP project

Error: Apache shutdown unexpectedly.

This may be due to a blocked port, missing dependencies,10:46:37 [Apache] improper privileges, a crash, or a shutdown by another method. Solution: Open XAMPP Control Penal and…

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x