#mysql #xampp
Вопрос:
Это первый раз, когда я использую 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
Ответ №1:
Я столкнулся с чем-то подобным еще тогда, когда устанавливал MySQL-сообщество после Xampp в Windows. Итак, предполагая, что вы находитесь в Windows:
- CTRL R, введите services.msc
- Остановите все запущенные службы mysql
- Запустите MySQL на Xampp
Если это сработало, то это означает, что у вас есть 2 установки MySQL (1 из которых от Xampp), и обе они прослушивают порт 3306, как следует из сообщения об ошибке. Измените один из них на прослушивание другого порта, 3307 или что-то в этом роде.