mySQL server in XAMP don't start

7
votes

I read all of articles about my problem but it still not working

How can I solve this issue?

Here is my log file: 

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

2016-06-02 14:23:12 c10 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.
2016-06-02 14:23:12 3088 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:23:12 3088 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:23:12 3088 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:23:12 3088 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:23:12 3088 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:23:12 3088 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:23:12 3088 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:23:12 3088 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:23:12 3088 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:23:12 3088 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:23:12 3088 [Note] InnoDB: Waiting for purge to start
2016-06-02 14:23:12 3088 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835037
2016-06-02 14:23:12 6804 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:23:12 3088 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:23:12 3088 [Note] Server socket created on IP: '::'.
2016-06-02 14:23:12 3088 [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.


2016-06-02 14:23:12 3088 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:23:12 3088 [ERROR] Aborting

2016-06-02 14:48:22 4256 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:48:22 10a0 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.
2016-06-02 14:48:22 4256 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:48:22 4256 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:48:22 4256 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:48:22 4256 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:48:22 4256 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:48:22 4256 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:48:22 4256 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:48:22 4256 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:48:22 4256 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:48:22 4256 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:48:22 4256 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:48:22 4256 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:48:22 4524 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:48:22 4256 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:48:22 4256 [Note] Server socket created on IP: '::'.
2016-06-02 14:48:22 4256 [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.


2016-06-02 14:48:22 4256 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:48:22 4256 [ERROR] Aborting

2016-06-02 14:48:26 6448 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:48:26 1930 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.
2016-06-02 14:48:26 6448 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:48:26 6448 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:48:26 6448 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:48:26 6448 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:48:26 6448 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:48:26 6448 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:48:26 6448 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:48:26 6448 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:48:26 6448 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:48:26 6448 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:48:26 6448 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:48:26 6448 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:48:26 5968 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:48:26 6448 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:48:26 6448 [Note] Server socket created on IP: '::'.
2016-06-02 14:48:26 6448 [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.


2016-06-02 14:48:26 6448 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:48:26 6448 [ERROR] Aborting

2016-06-02 14:48:29 5836 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:48:29 16cc 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.
2016-06-02 14:48:29 5836 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:48:29 5836 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:48:29 5836 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:48:29 5836 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:48:29 5836 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:48:29 5836 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:48:29 5836 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:48:29 5836 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:48:29 5836 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:48:29 5836 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:48:29 5836 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:48:29 5836 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:48:29 8112 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:48:29 5836 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:48:29 5836 [Note] Server socket created on IP: '::'.
2016-06-02 14:48:29 5836 [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.


2016-06-02 14:48:29 5836 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:48:29 5836 [ERROR] Aborting

2016-06-02 14:49:50 7448 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:49:50 1d18 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.
2016-06-02 14:49:50 7448 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:49:50 7448 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:49:50 7448 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:49:50 7448 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:49:50 7448 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:49:50 7448 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:49:50 7448 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:49:50 7448 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:49:50 7448 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:49:51 7448 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:49:51 7448 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:49:51 7448 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:49:51 3128 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:49:51 7448 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:49:51 7448 [Note] Server socket created on IP: '::'.
2016-06-02 14:49:51 7448 [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.


2016-06-02 14:49:51 7448 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:49:51 7448 [ERROR] Aborting

2016-06-02 14:49:58 1512 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:49:58 5e8 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.
2016-06-02 14:49:58 1512 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:49:58 1512 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:49:58 1512 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:49:58 1512 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:49:58 1512 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:49:58 1512 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:49:58 1512 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:49:58 1512 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:49:58 1512 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:49:58 1512 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:49:58 1512 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:49:58 1512 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:49:58 4724 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:49:58 1512 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:49:58 1512 [Note] Server socket created on IP: '::'.
2016-06-02 14:49:58 1512 [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.


2016-06-02 14:49:58 1512 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:49:58 1512 [ERROR] Aborting

2016-06-02 14:50:01 5360 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:50:01 14f0 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.
2016-06-02 14:50:01 5360 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:50:01 5360 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:50:01 5360 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:50:01 5360 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:50:01 5360 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:50:01 5360 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:50:01 5360 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:50:01 5360 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:50:01 5360 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:50:01 5360 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:50:01 5360 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:50:01 5360 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:50:01 1264 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:50:01 5360 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:50:01 5360 [Note] Server socket created on IP: '::'.
2016-06-02 14:50:01 5360 [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.


2016-06-02 14:50:01 5360 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:50:01 5360 [ERROR] Aborting

2016-06-02 14:53:10 4928 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:53:10 1340 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.
2016-06-02 14:53:10 4928 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:53:10 4928 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:53:10 4928 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:53:10 4928 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:53:10 4928 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:53:10 4928 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:53:10 4928 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:53:10 4928 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:53:10 4928 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:53:10 4928 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:53:10 4928 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:53:10 4928 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:53:10 5072 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:53:10 4928 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:53:10 4928 [Note] Server socket created on IP: '::'.
2016-06-02 14:53:10 4928 [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.


2016-06-02 14:53:10 4928 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:53:10 4928 [ERROR] Aborting

2016-06-02 14:58:04 5244 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:58:04 147c 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.
2016-06-02 14:58:04 147c InnoDB: Warning: Setting innodb_use_sys_malloc to FALSE is DEPRECATED. This option may be removed in future releases, together with the InnoDB's internal memory allocator.
2016-06-02 14:58:04 5244 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:58:04 5244 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:58:04 5244 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:58:04 5244 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:58:04 5244 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:58:04 5244 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:58:04 5244 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:58:04 5244 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:58:05 5244 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:58:05 5244 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:58:05 5244 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:58:05 332 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:58:05 5244 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:58:05 5244 [Note] Server socket created on IP: '::'.
2016-06-02 14:58:05 5244 [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.


2016-06-02 14:58:05 5244 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:58:05 5244 [ERROR] Aborting

2016-06-02 14:59:17 4716 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:59:17 126c 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.
2016-06-02 14:59:17 126c InnoDB: Warning: Setting innodb_use_sys_malloc to FALSE is DEPRECATED. This option may be removed in future releases, together with the InnoDB's internal memory allocator.
2016-06-02 14:59:17 4716 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:59:17 4716 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:59:17 4716 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:59:17 4716 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:59:17 4716 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:59:17 4716 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:59:17 4716 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:59:17 4716 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:59:17 4716 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:59:17 4716 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:59:17 4716 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:59:17 4716 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:59:17 4652 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:59:17 4716 [Note] Server socket created on IP: '::'.
2016-06-02 14:59:17 4716 [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.


2016-06-02 14:59:17 4716 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:59:17 4716 [ERROR] Aborting

2016-06-02 14:59:30 4916 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:59:30 1334 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.
2016-06-02 14:59:30 1334 InnoDB: Warning: Setting innodb_use_sys_malloc to FALSE is DEPRECATED. This option may be removed in future releases, together with the InnoDB's internal memory allocator.
2016-06-02 14:59:30 4916 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:59:30 4916 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:59:30 4916 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:59:30 4916 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:59:30 4916 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:59:30 4916 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:59:30 4916 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:59:30 4916 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:59:30 4916 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:59:30 4916 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:59:30 4916 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:59:30 4404 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:59:30 4916 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:59:30 4916 [Note] Server socket created on IP: '::'.
2016-06-02 14:59:30 4916 [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.


2016-06-02 14:59:30 4916 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:59:30 4916 [ERROR] Aborting

Thanks.

7
mysql
Change the port and try again? – gaganso
@SilentMonk is right, it seems like that port is taken by some other process and the mysqld cant use. – Daniel Netzer
it is used by another mysql instance that was not properly closed. I assume that you are on windows, I think you can kill previous mysql processes or restart the computer. – Elzo Valugi

7 Answers

16
votes

I ran into this same issue when I had MySQL Workbench and XAMPP downloaded. Since they're both trying to access Port 3306 an error occurs. I'm running this on Windows 10, I'm not sure if this fix also works on Mac & Linux. I changed the port of XAMPP to 3307 and left the MySQL untouched. Here's how I did that: *Take into consideration that the line numbers may be different on your system.

  1. In the XAMPP GUI click on "Config" -> "Service and Port Settings" -> "MySQL" tab -> Change Main Port to 3307 -> Save -> Save

  2. Locate the installation file for XAMPP -> open MySQL folder -> open bin folder -> right click on "my.ini" and edit it

  3. Change the following lines: (Line 20) Port = 3306 -> Port = 3307 (Line 28) Port = 3306 -> Port = 3307

Save the file, restart your computer, and the server should run.

9
votes

I just ran into this problem myself after I installed XAMPP for APACHE. I decided to use it for a localhost of MySQL too. Here's what I did to get it to work.

In windows, open command prompt, type: netstat -ano|find "3306"

The PID LISTENING was 4608. Opened Task Manager, went to Details tab. Found the PID, it was a mysql.exe from another application. Right click the application and select End Task.

Restart XAMPP.

I don't recommend changing the Port Number just because 3306 is a Standard assigned port to MySQL as well as 33060, 33061, and 33062. In a few cases, I have seen Port 22 assigned. There is a protocol set up for this and when to use which one.

2
votes

I had the same case because in someway i installed MariaDB and it used the port of 3306, so what i did is to go to the Task-manager > Services and did a sort to find the port using "3306" in PID column then i stop that service. after i started MySQL in the xampp control panel and it worked very well.

My conclusion is that you should use command option (1):

  1. netstat -ano|find "3306"
  2. find that port in Task-manager > Services
  3. stop the application using that port in PID
  4. Click to start MySQL again.
1
votes

I just encountered this error. Since I have Xampp and MySQL Workbench, I had a feeling that the issue was MySQL related thus I opened the task Manager using

ctrl+shift+del

and selecting Task Manager.

Then on the services tab, I searched for any running MySQL programs, left-clicked it, and stopped it.

Then started MySQL on the Xampp control panel.

I think you can try this first then proceed to other options in case it doesn't work.

1
votes

Windows 10 Microsoft Windows [version 10.0.19041.450] Laragon 4.0.16 190914 (MySQL 5.7.24_winx64) on 3306 Xampp 3.2.4 (10.4.13-MariaDB) on 3306

Some log error lines of MySQL 5.7.24_winx64 on 3306 on Laragon 4.0.16 190914 :

  • '::' resolves to '::'; Server socket created on IP: '::'. Can't start server: Bind on TCP/IP port: No such file or directory

No way to fix this (sfc /scannow, change port to 3307=nok) so I decided to remove HyperV/Sandbox and all Windows 10 options related to HyperV (lan adapters issues ?).

After the removals of the HyperV Windows 10 options + reboot, Laragon MySQL and Xampp MariaDB are working like a charm!

0
votes

Agree with @Daniel and @Elzo

Try to run this below command in cmd prompt

netstat -ano|find "3306"

Eg:

TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING 5164

TCP [::]:3306 [::]:0 LISTENING 5164

It will let you know whether any process is utilizing port 3306 or not.

If you are using xampp older version of xampp had portcheck.ext file you could even use that.

If its mysql than stop and then try to start mysql again. You could even use the pid number(Here 5164) and check in windows task manager who is utilizing these pid so that you would come to know the exact process name

0
votes

Try this command :

-> netstat -ano|find "3306"

and go to Task manager -> services or Task manager -> details check your running 
PID on port 3306 and end that task.

restart your MySQL it's work!!