Bug at the end of installation

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

Bug at the end of installation

Postby Herpe » 31. May 2019 19:25

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!
Posts: 1
Joined: 31. May 2019 19:19
XAMPP version: control panel v3.2.3
Operating System: Windows 10

Re: Bug at the end of installation

Postby Nobbie » 01. June 2019 10:46

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.
Posts: 10965
Joined: 09. March 2008 13:04

Return to XAMPP for Windows

Who is online

Users browsing this forum: foreverlearning and 49 guests