Apache Friends Support Forum

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


The log:

2015-11-10 15:26:56 10fc 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.
2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2019-11-18 00:32:52 415c 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-11-18 0:32:52 16732 [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-11-18 0:32:52 16732 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-11-18 0:32:52 16732 [Note] InnoDB: The InnoDB memory heap is disabled
2019-11-18 0:32:52 16732 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-18 0:32:52 16732 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-11-18 0:32:52 16732 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-11-18 0:32:52 16732 [Note] InnoDB: Using generic crc32 instructions
2019-11-18 0:32:52 16732 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-11-18 0:32:52 16732 [Note] InnoDB: Completed initialization of buffer pool
2019-11-18 0:32:54 16732 [Note] InnoDB: Highest supported file format is Barracuda.
2019-11-18 0:32:57 16732 [Note] InnoDB: 128 rollback segment(s) are active.
2019-11-18 0:32:57 16732 [Note] InnoDB: Waiting for purge to start
2019-11-18 0:32:57 16732 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1835037
2019-11-18 0:32:58 16276 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-11-18 0:32:58 16732 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-18 0:32:58 16732 [Note] Server socket created on IP: '::'.
2019-11-18 0:32:58 16732 [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.


2019-11-18 0:32:58 16732 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-11-18 0:32:58 16732 [ERROR] Aborting

2019-11-18 00:34:37 2308 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-11-18 0:34:37 8968 [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-11-18 0:34:37 8968 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-11-18 0:34:37 8968 [Note] InnoDB: The InnoDB memory heap is disabled
2019-11-18 0:34:37 8968 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-18 0:34:37 8968 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-11-18 0:34:37 8968 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-11-18 0:34:37 8968 [Note] InnoDB: Using generic crc32 instructions
2019-11-18 0:34:37 8968 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-11-18 0:34:37 8968 [Note] InnoDB: Completed initialization of buffer pool
2019-11-18 0:34:38 8968 [Note] InnoDB: Highest supported file format is Barracuda.
2019-11-18 0:34:39 8968 [Note] InnoDB: 128 rollback segment(s) are active.
2019-11-18 0:34:39 8968 [Note] InnoDB: Waiting for purge to start
2019-11-18 0:34:39 8968 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1835047
2019-11-18 0:34:39 20960 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-11-18 0:34:39 8968 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-18 0:34:39 8968 [Note] Server socket created on IP: '::'.
2019-11-18 0:34:39 8968 [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.


2019-11-18 0:34:39 8968 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-11-18 0:34:39 8968 [ERROR] Aborting

2019-11-18 00:36:04 4e70 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-11-18 0:36:04 20080 [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-11-18 0:36:04 20080 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-11-18 0:36:04 20080 [Note] InnoDB: The InnoDB memory heap is disabled
2019-11-18 0:36:04 20080 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-18 0:36:04 20080 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-11-18 0:36:04 20080 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-11-18 0:36:04 20080 [Note] InnoDB: Using generic crc32 instructions
2019-11-18 0:36:04 20080 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-11-18 0:36:04 20080 [Note] InnoDB: Completed initialization of buffer pool
2019-11-18 0:36:04 20080 [Note] InnoDB: Highest supported file format is Barracuda.
2019-11-18 0:36:05 20080 [Note] InnoDB: 128 rollback segment(s) are active.
2019-11-18 0:36:05 20080 [Note] InnoDB: Waiting for purge to start
2019-11-18 0:36:05 20080 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1835057
2019-11-18 0:36:06 19268 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-11-18 0:36:06 20080 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-18 0:36:06 20080 [Note] Server socket created on IP: '::'.
2019-11-18 0:36:06 20080 [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.


2019-11-18 0:36:06 20080 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-11-18 0:36:06 20080 [ERROR] Aborting

2019-11-18 00:38:45 5288 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-11-18 0:38:45 21128 [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-11-18 0:38:45 21128 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-11-18 0:38:45 21128 [Note] InnoDB: The InnoDB memory heap is disabled
2019-11-18 0:38:45 21128 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-18 0:38:45 21128 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-11-18 0:38:45 21128 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-11-18 0:38:45 21128 [Note] InnoDB: Using generic crc32 instructions
2019-11-18 0:38:45 21128 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-11-18 0:38:45 21128 [Note] InnoDB: Completed initialization of buffer pool
2019-11-18 0:38:45 21128 [Note] InnoDB: Highest supported file format is Barracuda.
2019-11-18 0:38:46 21128 [Note] InnoDB: 128 rollback segment(s) are active.
2019-11-18 0:38:46 21128 [Note] InnoDB: Waiting for purge to start
2019-11-18 0:38:46 21128 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1835067
2019-11-18 0:38:46 21064 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-11-18 0:38:46 21128 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-18 0:38:46 21128 [Note] Server socket created on IP: '::'.
2019-11-18 0:38:47 21128 [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.


2019-11-18 0:38:47 21128 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-11-18 0:38:47 21128 [ERROR] Aborting

Maybe you got another MySQL/MariaDB Server running already?
What is the full contents of your XAMPP control panel log?

Altrea wrote:Maybe you got another MySQL/MariaDB Server running already?
What is the full contents of your XAMPP control panel log?

Yeah, I'm trying to run 2 different xampp installations on my system but I do not start them simultaneously. Been trying to add another virtual host for different WordPress sites but it ain't working, hence I tried installing another xampp.