XAMPP 3.2.2 Win 10 MySQL Start Fehler

[michael.waeltl]

Hier mein log, was ist das Problem? Was ist die Lösung?

VG

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

2017-12-20 01:18:14 1824 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.
2017-12-20 1:18:15 6180 [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.

2017-12-20 1:18:15 6180 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-12-20 1:18:15 6180 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-20 1:18:15 6180 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-12-20 1:18:15 6180 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-12-20 1:18:15 6180 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-20 1:18:15 6180 [Note] InnoDB: Using generic crc32 instructions
2017-12-20 1:18:15 6180 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-12-20 1:18:15 6180 [Note] InnoDB: Completed initialization of buffer pool
2017-12-20 1:18:15 6180 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-20 1:18:15 6180 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-20 1:18:15 6180 [Note] InnoDB: Waiting for purge to start
2017-12-20 1:18:15 6180 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1835037
2017-12-20 1:18:15 6892 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-12-20 1:18:15 6180 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-20 1:18:15 6180 [Note] Server socket created on IP: '::'.
2017-12-20 1:18:15 6180 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Normalerweise darf jede Socketadresse (Protokoll, Netzwerkadresse oder Anschluss) nur jeweils einmal verwendet werden.


2017-12-20 1:18:15 6180 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-12-20 1:18:15 6180 [ERROR] Aborting

2017-12-20 01:27:15 3650 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.
2017-12-20 1:27:15 13904 [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.

2017-12-20 1:27:15 13904 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-12-20 1:27:15 13904 [Note] InnoDB: The InnoDB memory heap is disabled
2017-12-20 1:27:15 13904 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-12-20 1:27:15 13904 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-12-20 1:27:15 13904 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-12-20 1:27:15 13904 [Note] InnoDB: Using generic crc32 instructions
2017-12-20 1:27:15 13904 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-12-20 1:27:15 13904 [Note] InnoDB: Completed initialization of buffer pool
2017-12-20 1:27:15 13904 [Note] InnoDB: Highest supported file format is Barracuda.
2017-12-20 1:27:15 13904 [Note] InnoDB: 128 rollback segment(s) are active.
2017-12-20 1:27:15 13904 [Note] InnoDB: Waiting for purge to start
2017-12-20 1:27:15 13904 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1835047
2017-12-20 1:27:15 10680 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-12-20 1:27:15 13904 [Note] Plugin 'FEEDBACK' is disabled.
2017-12-20 1:27:15 13904 [Note] Server socket created on IP: '::'.
2017-12-20 1:27:15 13904 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Normalerweise darf jede Socketadresse (Protokoll, Netzwerkadresse oder Anschluss) nur jeweils einmal verwendet werden.


2017-12-20 1:27:15 13904 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-12-20 1:27:15 13904 [ERROR] Aborting

[Nobbie]

was ist das Problem?

Was im Log geschrieben steht:

2017-12-20 1:27:15 13904 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Normalerweise darf jede Socketadresse (Protokoll, Netzwerkadresse oder Anschluss) nur jeweils einmal verwendet werden.
2017-12-20 1:27:15 13904 [ERROR] Do you already have another mysqld server running on port: 3306 ?

Was ist die Lösung?

Nachschauen (oder sich erinnern) ob ein anderer mysql Server schon läuft. In seltenen Fällen wird auch versucht, den gleichen Server doppelt zu starten, oder in sehr seltenen Fällen blockiert eine Firewall. Der Taskmanager ist eine große Hilfe, auch im Xampp Controldialog gibt es oben rechts hilfreiche Buttons u.a. "Netstat". Du musst herausfinden, wieso Port 3306 blockiert (belegt) ist.