MySQL won't start on XAMPP server

Question

I have a problem with my XAMPP server. I can start Apache, FileZilla, and every thing else without problems, but when I try to start MySQL, it just says

Attempting to start MySQL service...

and it stays like that forever, like if it was frozen or something.

Any ideas how to fix it?

Answer 1

Check the log files for MySQL. You will find them in this directory: C:\xampp\mysql\data (assuming standard install location of xampp)

Also check if no other program or service uses the default MySql port. You can do this by using this command:

netstat -an | findstr "3306"

If anything shows up the default mysql port is in use.

Answer 2

I fetch the problem to start xampp services "mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files"

I delete all area_log files form xampp\mysql\data

after that I restart XAMPP than it works.

Thanks