XAMPP MySQL Does Not Start

Asked 2 years ago, Updated 2 years ago, 116 views

Even if you click "start" from the XAMPP company,
It will run for a moment, but an error will occur immediately and it will be stopped.

 5:19:43 [mysql] Attempting to start MySQL app...
5:19:43 [mysql] Status change detected:running
5:19:45 [mysql] Status change detected: stopped
5:19:45 [mysql]    Error: MySQL shutdown unexpectedly.
5:19:45 [mysql] This may be due to a blocked port, missing dependencies, 
5:19:45 [mysql]improper privileges, a crash, or a shutdown by another method.
5:19:45 [mysql] Press the Logs button to view error logs and check
5:19:45 [mysql]    The Windows Event Viewer for more clouds
5:19:45 [mysql] If you need more help, copy and post this
5:19:45 [mysql] entire log window on the forums

Looking at the error log mysql_error.log

InnoDB:using atomic writes.
2019-12-255:19:430 [Note]InnoDB: The first innodb_system data file 'ibdata1' did not exist.A new tablespace will be created!
2019-12-255:19:430 [Note]InnoDB:Mutexes and rw_locks use Windows interlocked functions
2019-12-255:19:430 [Note]InnoDB:Uses event mutexes
2019-12-255:19:430 [Note]InnoDB: Compressed tables use zlib 1.2.11
2019-12-255:19:430 [Note]InnoDB: Number of pools:1
2019-12-255:19:430 [Note]InnoDB:Using SSE2crc32 instructions
2019-12-255:19:430 [Note]InnoDB: Initializing buffer pool, total size=16M, instances=1, chunk size=16M
2019-12-255:19:430 [Note]InnoDB:Completed initialization of buffer pool
2019-12-255:19:430 [Note]InnoDB: Setting file 'C:\xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait...
2019-12-255:19:430 [Note]InnoDB:File'C:\xampp\mysql\data\ibdata1'size is now 10 MB.
2019-12-255:19:430 [Note]InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2019-12-255:19:430 [Note]InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile 1 size to 5242880 bytes
2019-12-255:19:430 [Note]InnoDB:Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2019-12-255:19:430 [Note]InnoDB:New log files created,LSN=17992
2019-12-255:19:430 [Note]InnoDB: Doublewrite buffer not found:creating new
2019-12-255:19:430 [Note]InnoDB: Doublewrite buffer created
2019-12-255:19:430 [Note]InnoDB: 128 out of 128 rollback segments are active.
2019-12-255:19:430 [Note]InnoDB: Creating foreign key constraint system tables.
2019-12-255:19:430 [Note]InnoDB: Creating tablespace and datafile system tables.
2019-12-255:19:430 [Note]InnoDB:Creating sys_virtual system tables.
2019-12-255:19:430 [Note]InnoDB:Creating shared tablespace for temporary tables
2019-12-255:19:430 [Note]InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait...
2019-12-255:19:430 [Note]InnoDB:File'C:\xampp\mysql\data\ibtmp1'size is now 12 MB.
2019-12-255:19:430 [Note]InnoDB: Waiting for purge to start
2019-12-255:19:430 [Note]InnoDB:10.4.10 started; log sequence number 0;transaction id 7
2019-12-255:19:430 [Note] Plugin'FEEDBACK' is disabled.
2019-12-255:19:430 [Note] Server socket created on IP: '::'.

Tried a few things

  • When I check portcheck.bat, it doesn't look like the port is wearing it.I tried to change the port to something else, but it didn't start.
  • From xampp>mysql>my.ini

    #default-character-set=utf8
    

    commented out.

  • I deleted the ib_logfile0, ib_logfile1, ibdata1 in xampp>mysql>data and then tried, but it didn't start.

  • I saw information that xampp was uninstalled → reinstalled, but I would like to avoid it because it already runs a website within xampp's htdocs.

in xampp>mysql>my.ini
#default-character-set=utf8

commented out.

I deleted ib_logfile0, ib_logfile1, ibdata1 in xampp>mysql>data and then tried, but it didn't start.

I saw information that xampp was uninstalled → reinstalled, but I would like to avoid it because it already runs a website within xampp's htdocs.

Q: What other measures can you think of?If anyone knows, I would appreciate it if you could reply.

mysql xampp

2022-09-29 22:14

1 Answers

Resolved by reinstalling XAMPP

This post was posted as a community wiki based on @atsushi_kane's comments.


2022-09-29 22:14

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.