MySQ

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 go to Services and click here

Open Services and scroll down and find the ( World Wide Web Publishing services )

When we click World Wide Web Publishing then shows the Stop and Restart option on the top side. Then click the Stop the services.

Now Open and Restart your XAMPP Control Penal

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