mySQL crashing

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

mySQL crashing

Postby enan26 » 17. April 2023 05:01

I was working and had a power failure yesterday

When I am trying to log in today mySQL keeps on crashing.

the log from the XAMPP control panel is pasted below.


11:42:25 am [main] Initializing Control Panel
11:42:25 am [main] Windows Version: Home 64-bit
11:42:25 am [main] XAMPP Version: 8.2.0
11:42:25 am [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]
11:42:25 am [main] You are not running with administrator rights! This will work for
11:42:25 am [main] most application stuff but whenever you do something with services
11:42:25 am [main] there will be a security dialogue or things will break! So think
11:42:25 am [main] about running this application with administrator rights!
11:42:25 am [main] XAMPP Installation Directory: "d:\xampp\"
11:42:25 am [main] Checking for prerequisites
11:42:26 am [main] All prerequisites found
11:42:26 am [main] Initializing Modules
11:42:26 am [main] Starting Check-Timer
11:42:26 am [main] Control Panel Ready
11:42:37 am [Apache] Attempting to start Apache app...
11:42:37 am [Apache] Status change detected: running
11:42:46 am [mysql] Attempting to start MySQL app...
11:42:46 am [mysql] Status change detected: running
11:42:49 am [mysql] Status change detected: stopped
11:42:49 am [mysql] Error: MySQL shutdown unexpectedly.
11:42:49 am [mysql] This may be due to a blocked port, missing dependencies,
11:42:49 am [mysql] improper privileges, a crash, or a shutdown by another method.
11:42:49 am [mysql] Press the Logs button to view error logs and check
11:42:49 am [mysql] the Windows Event Viewer for more clues
11:42:49 am [mysql] If you need more help, copy and post this
11:42:49 am [mysql] entire log window on the forums

Any suggestions?

thank you! :)
enan26
 
Posts: 1
Joined: 17. April 2023 04:54
XAMPP version: 8.2.0
Operating System: Windows 11

Re: mySQL crashing

Postby Altrea » 17. April 2023 07:26

Hi,

your logs don't contain any helpful information about your issue.

Please try to start MariaDB as console application and tell us what log messages you get there:
  • start the XAMPP shell by clicking the [Shell] button in your XAMPP control panel
  • execute the following command
    Code: Select all
    mysqld --defaults-file=mysql\bin\my.ini --standalone --console
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11952
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 132 guests