Issues with xampp and mysql after windows 11

[giulietta09]

Hello, today I've installed Windows 11 and I have some issues with xampp and the database that doesn't work.
In localhost/phpmyadmin I see this errors - Message from MySql: Unable to connect: invalid settings.
Packets out of order. Expected 0 received 1. Packet size=%Id
mysqli::real_connect(): Error while reading greeting packet. PID=6780
mysqli::real_connect(): (HY000/2006): MySQL server has gone away
Connection for controluser as defined in the configuration failed.
Packets out of order. Expected 0 received 1. Packet size=%Id
mysqli::real_connect(): Error while reading greeting packet. PID=6780
mysqli::real_connect(): (HY000/2006): MySQL server has gone away
phpMyAdmin tried to connect to the MySQL server, and the server refused the connection. You should check the host name, username and password in the configuration file and make sure they match the information provided by the MySQL server administrator.


I have tried to set the user and password, but they were already right.

Could someone help me, please?
Thank you

[Froosh]

I have Windows 11 Pro installed, and XAMPP 8.1.2 installed. Works like a champ for me. You might want to provide some additional details on your version of XAMPP and environment.

[billybob]

Hi giulietta09
I have the same xampp version as you and i recently had similar error, not sure it's related to windows 11 by the way.
Were you able to fix your problem?
Thanks

[Sepp van de Manakker]

After starting mysql i see this:
08:37:12 [Apache] Attempting to start Apache app...
08:37:12 [Apache] Status change detected: running
08:37:28 [mysql] Attempting to start MySQL app...
08:37:28 [mysql] Status change detected: running
08:37:28 [mysql] Status change detected: stopped
08:37:28 [mysql] Error: MySQL shutdown unexpectedly.
08:37:28 [mysql] This may be due to a blocked port, missing dependencies,
08:37:28 [mysql] improper privileges, a crash, or a shutdown by another method.
08:37:28 [mysql] Press the Logs button to view error logs and check
08:37:28 [mysql] the Windows Event Viewer for more clues
08:37:28 [mysql] If you need more help, copy and post this
08:37:28 [mysql] entire log window on the forums

Waht i have found out, something breaks in the folder xampp/mysql
Please help

[Sepp van de Manakker]

addional info:
On Windows 10 never had a problem with XAMPP
run XAMPP as administrator
installed Windows services Apache and MSQL
mysql log shows these errors:
2022-06-11 10:41:58 0 [ERROR] mysqld: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-06-11 10:41:58 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-06-11 10:41:58 0 [ERROR] Aborting

[Sepp van de Manakker]

narrowed down the problem a bit with help of an item on:
https://stackoverflow.com/questions/62797324/unable-to-start-mysql-via-xampp-mysql-db-crashed

1. add 'skip-grant-tables' to xampp/mysql/bin/my.ini just after the label [mysqld], so phpmyadmin will start up without checks.
2. in the database called 'mysql' repair the table called 'db' in the same way as deleting a table, there is an option 'repair table'
3. remove 'skip-grant-tables' from xampp/mysql/bin/my.ini

next question: why is the table corrupted ?

[macksix]

The only time I had problems is shutting down MariaDB with the XAMPP control panel and since I stopped doing that and using Services to start and stop it, I never have problems.

[luandiego7]

I have the same problem. Since i installed the windows 11, the xampp always crash. The xampp always shutdown unexpectedly. When i was using windows 10, i never had problem with xampp.

[pgielen]

I am getting the feeling more and more that Windows 11 is what Windows Vista was for Windows XP: a complete disaster meant to prepare the minds for the arrival of a next, great windows version.

[Altrea]

I do have no problems with Windows 11.
Works like a charm like Windows 10.

[Froosh]

Yep. Windows 11 has been solid, and fine for my purposes. No issues with it, or Windows 10 either.