XAMP中的MySQL服务器无法启动

Question

我阅读了所有关于我的问题的文章，但仍然无法解决

我该如何解决这个问题？

这是我的日志文件：

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

谢谢。

- alibar

---

更改端口，再试一次？ - gaganso

@SilentMonk 是正确的，看起来该端口已被其他进程占用，因此 mysqld 无法使用。 - Daniel Netzer

它被另一个未正确关闭的MySQL实例所使用。我假设你在使用Windows，你可以杀掉之前的MySQL进程或重新启动计算机。 - Elzo Valugi

在Linux上，似乎罪魁祸首是MariaDB正在使用该端口。以下命令让我看到哪些程序占用了该端口：sudo lsof -i -P -n | grep LISTEN - gimmegimme

Answer 1

当我下载了MySQL Workbench和XAMPP时遇到了同样的问题。由于它们都尝试访问端口3306，因此会出现错误。我在Windows 10上运行此操作，不确定此解决方法是否也适用于Mac和Linux。 我将XAMPP的端口更改为3307，将MySQL保持不变。这是我如何做到的： *请考虑您的系统上行号可能会有所不同。

1. 在XAMPP GUI中单击“Config”->“Service and Port Settings”->“MySQL”选项卡->将主端口更改为3307->保存->保存

2. 找到XAMPP的安装文件->打开MySQL文件夹->打开bin文件夹->右键单击“my.ini”并编辑它

3. 更改以下行： (Line 20) Port = 3306 -> Port = 3307 (Line 28) Port = 3306 -> Port = 3307

保存文件，重新启动计算机，服务器应该可以运行。

- Ryan Russell

---

正如其他答案所述，更改端口号并不理想，因为3306是这种用例的标准端口。 - Derek718

非常感谢你，Ryan。在我的端上，我使用wnmp。根据你的解决方案，我关闭了xampp上的mysql服务。 - Two

我不知道。因为MySQL无法启动而更改MySQL端口就像告诉某人如果他们的汽车无法启动，使用另一辆汽车一样。这会转移对汽车#1实际存在的问题。 - TARKUS

@Ryan Russell，这很有效，但是除了Ryan给的步骤外，您还需要更改php.ini中的mysqli.default_port，否则phpmyadmin将无法正常启动。更改php.ini的步骤：

1. 在XAMPP控制面板中，在Apache下单击配置。
2. 选择PHP（php.ini）。
3. 将mysqli.default_port中的端口从3306更改为3307。

- Allan

@TARKUS 我的回答是一种缓解措施，而不是解决方案。如果您正在尝试在生产系统中运行此程序，您应该确保端口设置正确，否则可能会遇到更多问题。 - Ryan Russell

Answer 2

我在安装Apache的XAMPP后遇到了这个问题。我决定将其用于MySQL的本地主机。以下是我为使其正常工作所做的操作。

在Windows中，打开命令提示符，输入： netstat -ano|find "3306"

正在监听的PID是4608。 打开任务管理器，转到详细信息选项卡。 找到PID，它是来自另一个应用程序的mysql.exe。 右键单击该应用程序，然后选择“结束任务”。

重新启动XAMPP。

我不建议仅因为3306是MySQL分配的标准端口以及33060、33061和33062也是如此而更改端口号。在一些情况下，我看到端口22被分配。对此有一个协议，需要知道何时使用哪个端口。

- Brendan Walker

Answer 3

我刚遇到了这个错误。由于我有 XAMPP 和 MySQL Workbench，我觉得问题是 MySQL 相关的，因此我使用 Ctrl + Alt + Delete 打开任务管理器并选择任务管理器。

然后，在服务选项卡上，我搜索正在运行的 MySQL 程序，左键单击它并停止它。

接下来在 XAMPP 控制面板上启动 MySQL。

如果这种方法不奏效，你可以尝试其他选项。

- Doreen Chemweno

---

Ctrl + Alt + Del - Muhammad Mubashirullah Durrani

点赞，不是因为这是最终答案，而是因为这是首先要尝试的正确方法。 - TARKUS

Answer 4

我曾经也遇到过类似的情况，因为我安装了MariaDB并使用了3306端口，所以我去任务管理器 > 服务中查找PID列中使用"3306"端口的应用程序，然后停止该服务。之后我在xampp控制面板中启动MySQL，它就能正常工作了。

我的结论是你应该使用以下命令选项(1)：

1. netstat -ano|find "3306"
2. 在任务管理器 > 服务中查找该端口
3. 停止使用该端口的应用程序
4. 再次点击启动MySQL。

- MATOVU JOEL CLINTON

Answer 5

Windows 10：Microsoft Windows [版本 10.0.19041.450] Laragon 4.0.16 190914 (MySQL 5.7.24_winx64) 运行在 3306 端口上 Xampp 3.2.4 (10.4.13-MariaDB) 运行在 3306 端口上

以下是 Laragon 4.0.16 190914 上 MySQL 5.7.24_winx64 在 3306 端口的一些日志错误信息：

• '::' 解析成 '::'; 服务器套接字创建于 IP: '::'。 无法启动服务器：TCP/IP 端口绑定错误：没有那个文件或目录。

没有办法解决这个问题（sfc /scannow，将端口更改为 3307 不起作用），因此我决定删除 HyperV/Sandbox 以及所有与 HyperV 相关的 Windows 10 选项（lan 适配器问题？）。

在删除 HyperV Windows 10 选项并重新启动后，Laragon MySQL 和 Xampp MariaDB 就可以完美工作了！

- Léo De Hurlepet

Answer 6

我遇到了同样的问题。即使更换端口也无法运行。 最后我找到了这些命令并解决了问题。

以管理员身份运行命令提示符

输入 bcdedit /set hypervisorlaunchtype off

重新启动您的Windows

再次尝试运行XAMPP的MySQL，应该可以正常运行。

- Hirantha

Answer 7

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!!

- Nency Patel

Answer 8

同意 @Daniel 和 @Elzo 的观点

请在 cmd 命令提示符下尝试运行以下命令

netstat -ano|find "3306"

例如：

TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING 5164

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

这将让您知道是否有任何进程正在使用端口3306。

如果您使用的是旧版本的xampp，则有一个名为 portcheck.ext 的文件，您甚至可以使用它。

如果是mysql，则停止并尝试重新启动mysql。 您还可以使用pid号码（此处为5164）并在Windows任务管理器中检查谁正在使用这些pid，以便您可以了解实际的进程名称

- insoftservice

Answer 9

我只是删除了 MySql Workbench，不再出现这个错误。

- Muhammad Mubashirullah Durrani