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

Posted by

Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours scrolling social media and waste money on things we forget, but won’t spend 30 minutes a day earning certifications that can change our lives.
Master in DevOps, SRE, DevSecOps & MLOps by DevOps School!

Learn from Guru Rajesh Kumar and double your salary in just one year.


Get Started Now!

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

Leave a Reply

Your email address will not be published. Required fields are marked *

0
Would love your thoughts, please comment.x
()
x