Page 1 of 1

error when i start sql

PostPosted: 14. January 2024 11:15
by devil
Error: MySQL shutdown unexpectedly.
3:37:14 PM [mysql] This may be due to a blocked port, missing dependencies,
3:37:14 PM [mysql] improper privileges, a crash, or a shutdown by another method.
3:37:14 PM [mysql] Press the Logs button to view error logs and check
3:37:14 PM [mysql] the Windows Event Viewer for more clues
3:37:14 PM [mysql] If you need more help, copy and post this
3:37:14 PM [mysql] entire log window on the forums

Re: error when i start sql

PostPosted: 17. January 2024 14:03
by valez
to sort this problem,
1. click on the config button on the mysql port and select my.ini
2. scroll down to the mysqld and change the port to 3308 and close the notepad page.
3. go to your localdrive location and search for the xampp file, then sellect the phpmyadmin, select config.inc.php and open with notepad again
4. scroll down to the section with "/* Bind to the localhost ipv4 address and tcp */" and copy this code "$cfg['Servers'][$i]['connect_type'] = 'tcp';"
5. paste it just beneath the code but change the connect type to port and tcp to 3308.
6. save and close the file
7. go back to the xampp control panel and click on start on the mysql again and it should connect through.

or click on this link on youtube to watch the step by step process if you are not okay with my explanation https://youtu.be/8nutBUVxmQg?si=u05gDyM8ZhivqOUK

Re: error when i start sql

PostPosted: 20. January 2024 14:49
by Fopper
Got the same problem devil has, with the same Error messages.
I tried the solution Valez posted, but no result for me.
Is there something else i can try?

Re: error when i start sql

PostPosted: 25. January 2024 09:38
by demetris831
How to repair MySQL error
FIX [ERROR] mysqld.exe: Aria recovery failed in XAMPP

Procedures:
1. Stop Apache Server
2. Open C:\xampp\mysql\data

3. Delete: aria_log_control file

4. Exit
Start Apache Server
Start MySQL Server

Starts succesfully

Watch Video: https://www.youtube.com/watch?v=bjgFTM-oC-o

Re: error when i start sql

PostPosted: 25. January 2024 09:45
by demetris831
Fopper wrote:Got the same problem devil has, with the same Error messages.
I tried the solution Valez posted, but no result for me.
Is there something else i can try?


See my solution on this error,
Just post it today