How to fix startup error in MySQL in XAMPP?

0

Issue

When I run XAMPP and MySQL it gives "MySQL shutdown unexpectedly", I looked at other questions but they have different error logs, here is my error log. I have tried changing my back up folder and changing my port to 3307, but nothing seems to do anything. Thank you

2021-11-05 19:20:37 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-11-05 19:20:37 0 [ERROR] Aborting
2021-11-05 19:25:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-05 19:25:01 0 [Note] InnoDB: Uses event mutexes
2021-11-05 19:25:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-05 19:25:01 0 [Note] InnoDB: Number of pools: 1
2021-11-05 19:25:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-05 19:25:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-05 19:25:01 0 [Note] InnoDB: The log sequence number 300342 in the system tablespace does not match the log sequence number 300360 in the ib_logfiles!
2021-11-05 19:25:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-05 19:25:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-05 19:25:02 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-05 19:25:02 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-05 19:25:02 0 [Note] InnoDB: Waiting for purge to start
2021-11-05 19:25:02 0 [Note] InnoDB: 10.4.21 started; log sequence number 300360; transaction id 170
2021-11-05 19:25:02 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-05 19:25:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-05 19:25:02 0 [Note] Server socket created on IP: '::'.
2021-11-05 19:25:02 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

Solution

MySQL was running in the background, go into task manager and find the running process and click end task then try again. MySQL was not starting due to it being run in the background.

Answered By – KhushThakor

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave A Reply

Your email address will not be published.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More