这是我第一次使用XAMPP，当我运行XAMPP并启动mysql时，它一直中止它。我不知道我的驱动程序上是否缺少什么，我已经检查并更新了我的驱动程序，同样的事情发生了，我仍然得到了同样的错误。它说[错误]是否已经有另一个mysqld服务器运行在端口:3306上?
(错误)流产
这里是XAMPP日志
这是我的mysql_error.log
2021-07-31 8:55:47 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-31 8:55:47 0 [Note] InnoDB: Uses event mutexes
2021-07-31 8:55:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-31 8:55:47 0 [Note] InnoDB: Number of pools: 1
2021-07-31 8:55:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-31 8:55:47 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-31 8:55:47 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-31 8:55:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2021-07-31 8:55:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-31 8:55:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-31 8:55:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-31 8:55:47 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-31 8:55:47 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-07-31 8:55:47 0 [Note] InnoDB: Waiting for purge to start
2021-07-31 8:55:47 0 [Note] InnoDB: 10.4.20 started; log sequence number 300297; transaction id 170
2021-07-31 8:55:47 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-07-31 8:55:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-31 8:55:47 0 [Note] Server socket created on IP: '::'.
2021-07-31 8:55:47 0 [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.
2021-07-31 8:55:47 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-07-31 8:55:47 0 [ERROR] Aborting
2021-07-31 9:05:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-31 9:05:21 0 [Note] InnoDB: Uses event mutexes
2021-07-31 9:05:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-31 9:05:21 0 [Note] InnoDB: Number of pools: 1
2021-07-31 9:05:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-31 9:05:21 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-31 9:05:21 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-31 9:05:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-31 9:05:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-31 9:05:21 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-31 9:05:21 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-07-31 9:05:21 0 [Note] InnoDB: Waiting for purge to start
2021-07-31 9:05:21 0 [Note] InnoDB: 10.4.20 started; log sequence number 300306; transaction id 170
2021-07-31 9:05:21 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-07-31 9:05:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-31 9:05:21 0 [Note] Server socket created on IP: '::'.
2021-07-31 9:05:21 0 [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.
2021-07-31 9:05:21 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-07-31 9:05:21 0 [ERROR] Aborting
2021-07-31 9:10:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-31 9:10:27 0 [Note] InnoDB: Uses event mutexes
2021-07-31 9:10:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-31 9:10:27 0 [Note] InnoDB: Number of pools: 1
2021-07-31 9:10:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-31 9:10:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-31 9:10:27 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-31 9:10:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-31 9:10:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-31 9:10:27 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-31 9:10:27 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-07-31 9:10:27 0 [Note] InnoDB: Waiting for purge to start
2021-07-31 9:10:27 0 [Note] InnoDB: 10.4.20 started; log sequence number 300315; transaction id 170
2021-07-31 9:10:27 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-07-31 9:10:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-31 9:10:27 0 [Note] Server socket created on IP: '::'.
2021-07-31 9:10:27 0 [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.
2021-07-31 9:10:27 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-07-31 9:10:27 0 [ERROR] Aborting
2021-07-31 9:10:34 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-31 9:10:34 0 [Note] InnoDB: Uses event mutexes
2021-07-31 9:10:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-31 9:10:34 0 [Note] InnoDB: Number of pools: 1
2021-07-31 9:10:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-31 9:10:34 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-31 9:10:34 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-31 9:10:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-31 9:10:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-31 9:10:34 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-31 9:10:34 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-07-31 9:10:34 0 [Note] InnoDB: Waiting for purge to start
2021-07-31 9:10:34 0 [Note] InnoDB: 10.4.20 started; log sequence number 300324; transaction id 170
2021-07-31 9:10:34 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-07-31 9:10:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-31 9:10:34 0 [Note] Server socket created on IP: '::'.
2021-07-31 9:10:34 0 [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.
2021-07-31 9:10:34 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-07-31 9:10:34 0 [ERROR] Aborting
2021-07-31 9:20:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-31 9:20:30 0 [Note] InnoDB: Uses event mutexes
2021-07-31 9:20:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-31 9:20:30 0 [Note] InnoDB: Number of pools: 1
2021-07-31 9:20:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-31 9:20:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-31 9:20:30 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-31 9:20:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-31 9:20:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-31 9:20:30 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-31 9:20:30 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-07-31 9:20:30 0 [Note] InnoDB: Waiting for purge to start
2021-07-31 9:20:30 0 [Note] InnoDB: 10.4.20 started; log sequence number 300333; transaction id 170
2021-07-31 9:20:30 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-07-31 9:20:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-31 9:20:30 0 [Note] Server socket created on IP: '::'.
2021-07-31 9:20:30 0 [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.
2021-07-31 9:20:30 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-07-31 9:20:30 0 [ERROR] Aborting
2021-07-31 9:21:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-31 9:21:20 0 [Note] InnoDB: Uses event mutexes
2021-07-31 9:21:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-31 9:21:20 0 [Note] InnoDB: Number of pools: 1
2021-07-31 9:21:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-31 9:21:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-31 9:21:20 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-31 9:21:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-31 9:21:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-31 9:21:20 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-31 9:21:20 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-07-31 9:21:20 0 [Note] InnoDB: Waiting for purge to start
2021-07-31 9:21:20 0 [Note] InnoDB: 10.4.20 started; log sequence number 300342; transaction id 170
2021-07-31 9:21:20 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-07-31 9:21:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-31 9:21:20 0 [Note] Server socket created on IP: '::'.
2021-07-31 9:21:20 0 [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.
2021-07-31 9:21:20 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-07-31 9:21:20 0 [ERROR] Aborting
2021-07-31 9:22:15 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-31 9:22:15 0 [Note] InnoDB: Uses event mutexes
2021-07-31 9:22:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-31 9:22:15 0 [Note] InnoDB: Number of pools: 1
2021-07-31 9:22:15 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-31 9:22:15 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-31 9:22:15 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-31 9:22:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-31 9:22:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-31 9:22:15 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-31 9:22:15 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-07-31 9:22:15 0 [Note] InnoDB: Waiting for purge to start
2021-07-31 9:22:15 0 [Note] InnoDB: 10.4.20 started; log sequence number 300351; transaction id 170
2021-07-31 9:22:15 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-07-31 9:22:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-31 9:22:15 0 [Note] Server socket created on IP: '::'.
2021-07-31 9:22:15 0 [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.
2021-07-31 9:22:15 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-07-31 9:22:15 0 [ERROR] Aborting
2021-07-31 9:34:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-31 9:34:22 0 [Note] InnoDB: Uses event mutexes
2021-07-31 9:34:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-31 9:34:22 0 [Note] InnoDB: Number of pools: 1
2021-07-31 9:34:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-31 9:34:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-31 9:34:22 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-31 9:34:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-31 9:34:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-31 9:34:22 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-31 9:34:22 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-07-31 9:34:22 0 [Note] InnoDB: Waiting for purge to start
2021-07-31 9:34:22 0 [Note] InnoDB: 10.4.20 started; log sequence number 300360; transaction id 170
2021-07-31 9:34:22 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-07-31 9:34:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-31 9:34:22 0 [Note] Server socket created on IP: '::'.
2021-07-31 9:34:22 0 [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.
2021-07-31 9:34:22 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-07-31 9:34:22 0 [ERROR] Aborting
2021-07-31 9:34:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-31 9:34:32 0 [Note] InnoDB: Uses event mutexes
2021-07-31 9:34:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-31 9:34:32 0 [Note] InnoDB: Number of pools: 1
2021-07-31 9:34:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-31 9:34:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-31 9:34:32 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-31 9:34:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-31 9:34:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-31 9:34:32 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-31 9:34:32 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-07-31 9:34:32 0 [Note] InnoDB: Waiting for purge to start
2021-07-31 9:34:32 0 [Note] InnoDB: 10.4.20 started; log sequence number 300369; transaction id 170
2021-07-31 9:34:32 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-07-31 9:34:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-31 9:34:32 0 [Note] Server socket created on IP: '::'.
2021-07-31 9:34:32 0 [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.
2021-07-31 9:34:32 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-07-31 9:34:32 0 [ERROR] Aborting
2021-07-31 9:36:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-31 9:36:31 0 [Note] InnoDB: Uses event mutexes
2021-07-31 9:36:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-31 9:36:31 0 [Note] InnoDB: Number of pools: 1
2021-07-31 9:36:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-07-31 9:36:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-31 9:36:31 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-31 9:36:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-31 9:36:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-31 9:36:31 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-31 9:36:31 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-07-31 9:36:31 0 [Note] InnoDB: Waiting for purge to start
2021-07-31 9:36:31 0 [Note] InnoDB: 10.4.20 started; log sequence number 300378; transaction id 170
2021-07-31 9:36:31 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-07-31 9:36:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-31 9:36:31 0 [Note] Server socket created on IP: '::'.
2021-07-31 9:36:31 0 [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.
2021-07-31 9:36:31 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-07-31 9:36:31 0 [ERROR] Aborting
当我在Windows上安装Xampp之后安装MySQL社区时，我遇到了类似的问题。假设你在Windows上:
-
CTRL + R，输入services.msc
-
停止所有mysql服务
-
在Xampp上启动MySQL
如果这有效，那么这意味着您有2个MySQL安装(其中1个来自Xampp)，并且都像错误消息所提示的那样侦听端口3306。将其中一个更改为侦听另一个端口，例如3307或其他端口。