XAMPP 中的 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

谢谢。

Answer 1

我在下载 MySQL Workbench 和 XAMPP 时遇到了同样的问题。由于他们都试图访问端口 3306，因此发生错误。我在 Windows 10 上运行这个，我不确定这个修复是否也适用于 Mac 和 Linux。我将 XAMPP 的端口更改为 3307 并保持 MySQL 不变。我是这样做的:*请注意，您的系统上的行号可能不同。

1. 在 XAMPP GUI 中单击“配置”->“服务和端口设置”​​->“MySQL”选项卡-> 将主端口更改为 3307-> 保存-> 保存

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

3. 更改以下行:(第 20 行)端口 = 3306 -> 端口 = 3307(第 28 行)端口 = 3306 -> 端口 = 3307

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