php – How to make MySQL server in XAMPP work well after a crash?

exception or error:

The MySQL server in XAMPP does not start well anymore.

I tried changing the port as recommended here, and the server still does not start, although it attempts to do this: a new PID is shown for a fraction of second next to MySQL in the context of the screenshot below when clicking on Start.

I also tried to run netstat -ano|find "3306" (I tried with 3307 too) but it does not show anything, the same when running it in the Command Prompt as admin. I also restarted the computer and removed the new PHP code I wrote today. Yesterday everything worked fine.

Note: the day before yesterday I had my working computer instantly turned off by mistake.

A screenshot:

screenshot

The log file is here and a part of it says that it is a bug, but a bug of MariaDB which I do not use.

I am a beginner, I use MySQL just for WordPress.

Thank you.

Update 1

Running netstat -ab results in this.

Now I am checking if there are updates to XAMPP.

Update 2

It seems that there are no updates to XAMPP.

How to solve:

First of all check your port and check if your firewall is not blocking that port, try different ports 3306, 3307, 3308.

This is your error :

2020-02-20  9:40:14 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-02-20  9:40:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-02-20  9:40:14 0 [Note] Server socket created on IP: '::'.

I would re-install xampp instead of spending tons of time on trying to find error.

There are some explanition here : https://forums.mysql.com/read.php?10,652134,652135#msg-652135

Open shell from from control panel and start mysql with this command:

mysqld –-console –-skip-grant-tables –-skip-external-locking

Open another shell from control panel and repair database with this command:

mysqlcheck -r --databases mysql --use-frm

Stop mysql, close shells and restart mysql normally.

Also see InnoDB Corruption and Recovery https://chepri.com/mysql-innodb-corruption-and-recovery/

Leave a Reply

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