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
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.
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.
netstat -ab results in this.
Now I am checking if there are updates to XAMPP.
It seems that there are no updates to XAMPP.
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/