Apache Friends Support Forum

Hi people,

I installed the latest version of xampp on Windows 10 and at the end of the process, a bug happened. I tried to start MYSQL, but it failed and this message appeared :

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


I took a look at LOGS and this is was showed up :

2019-05-31 14:21:38 183c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-05-31 14:21:38 6204 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-05-31 14:21:38 6204 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-05-31 14:21:38 6204 [Note] InnoDB: The InnoDB memory heap is disabled
2019-05-31 14:21:38 6204 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-05-31 14:21:38 6204 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-05-31 14:21:38 6204 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-05-31 14:21:38 6204 [Note] InnoDB: Using generic crc32 instructions
2019-05-31 14:21:38 6204 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-05-31 14:21:38 6204 [Note] InnoDB: Completed initialization of buffer pool
2019-05-31 14:21:38 6204 [Note] InnoDB: Highest supported file format is Barracuda.
2019-05-31 14:21:38 6204 [Note] InnoDB: 128 rollback segment(s) are active.
2019-05-31 14:21:38 6204 [Note] InnoDB: Waiting for purge to start
2019-05-31 14:21:38 6204 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 1835057
2019-05-31 14:21:39 7696 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-05-31 14:21:39 6204 [Note] Plugin 'FEEDBACK' is disabled.
2019-05-31 14:21:39 6204 [Note] Server socket created on IP: '::'.
2019-05-31 14:21:39 6204 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Une seule utilisation de chaque adresse de socket (protocole/adresse réseau/port) est habituellement autorisée.


2019-05-31 14:21:39 6204 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-05-31 14:21:39 6204 [ERROR] Aborting

Does anybody knows how I can solve this? Thanks a lot for your help!

Is not a bug, on your PC the Port 3306 (MySQL) is already in use. Either from another program "Do you already have another mysqld server running on port: 3306 ?" (didnt you read that?), or your firewall is blocking it. Probably you have another MySQL server running.

Last not least, maybe you already started Xampp MySQL and you cannot start it twice.