Apache Friends Support Forum

Goodafternoon, my SQL shutdown unexpectedly,
i don't know exactly if i have to change the port's number of mySQL.
Actually the port's number of mySQL is 3306.
This is the error messagge appear in XAMPP comand:
Error: MySQL shutdown unexpectedly.
15:23:51 [mysql] This may be due to a blocked port, missing dependencies,
15:23:51 [mysql] improper privileges, a crash, or a shutdown by another method.
15:23:51 [mysql] Press the Logs button to view error logs and check
15:23:51 [mysql] the Windows Event Viewer for more clues
15:23:51 [mysql] If you need more help, copy and post this
15:23:51 [mysql] entire log window on the forums

I need a help please , thank you very much for your attention
regards
Daniele

Hey I just did this and it worked:

1. exit Xampp server
2. go to your C:\xampp\mysql\data directory
3. delete the ibdata1 file
4. restart xampp server
5. It should work

Thank you very much for your advise...
I was able to change the MySQL port number because it was occupied by another instance, and now the server works.

But Xampp's phpMyAdmin does not work properly because it fails to connect to my MySQL ...
I ask you for some tips on how to run phpMyAdmin thanks again to your help

Good evening,
my PC's Xampp phpMyAdmin fails to access MySQL.

This is the message that appears on the browser when loading localhost / phpMyAdmin:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

Do I have to reconfigure the configuration file?

Please ask your help on how to solve this problem
thanks for your attention
regards

You changed the MariaDB default port.
phpMyAdmin connects on IP and port.

So what do you think you are missing here!?