error when i start sql

Problems with the Windows version of XAMPP, questions, comments, and anything related.

error when i start sql

Postby devil » 14. January 2024 11:15

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
devil
 
Posts: 1
Joined: 14. January 2024 11:13
XAMPP version: 3.3.0
Operating System: Windows 10

Re: error when i start sql

Postby valez » 17. January 2024 14:03

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
valez
 
Posts: 1
Joined: 17. January 2024 13:54
XAMPP version: v3.3.0
Operating System: windows

Re: error when i start sql

Postby Fopper » 20. January 2024 14:49

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?
Fopper
 
Posts: 1
Joined: 19. January 2024 17:02
XAMPP version: v3.3.0
Operating System: W10

Re: error when i start sql

Postby demetris831 » 25. January 2024 09:38

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
demetris831
 
Posts: 2
Joined: 25. January 2024 09:34
XAMPP version: 8.2.12
Operating System: Windows 11

Re: error when i start sql

Postby demetris831 » 25. January 2024 09:45

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
demetris831
 
Posts: 2
Joined: 25. January 2024 09:34
XAMPP version: 8.2.12
Operating System: Windows 11


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 119 guests