minhminh12315
Junior Member
Các bác cho em hỏi cách fix lỗi với, e vừa tải mysql workbench và mysql sever ở trên pc và laptop nhưng chưa hề sử dụng đến. Nhưng hiện tại cả 2 máy của e đều k thể start được mysql trên xampp, đã thử dùng file backup vẫn không được rồi reinstall xampp cũng không được luôn ạ.
Dưới đây là mã mysql_error.log e mở ra ở phần Logs ạ
"
2024-02-24 12:44:09 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-02-24 12:44:09 0 [ERROR] Aborting
2024-02-24 17:16:55 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 5948
2024-02-24 17:16:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-24 17:16:55 0 [Note] InnoDB: Uses event mutexes
2024-02-24 17:16:55 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-24 17:16:55 0 [Note] InnoDB: Number of pools: 1
2024-02-24 17:16:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-24 17:16:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-24 17:16:55 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-24 17:16:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-24 17:16:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-24 17:16:55 0 [Note] InnoDB: Setting file 'Cxampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-24 17:16:55 0 [Note] InnoDB: File 'Cxampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-24 17:16:55 0 [Note] InnoDB: Waiting for purge to start
2024-02-24 17:16:55 0 [Note] InnoDB: 10.4.32 started; log sequence number 300333; transaction id 170
2024-02-24 17:16:55 0 [Note] InnoDB: Loading buffer pool(s) from Cxampp\mysql\data\ib_buffer_pool
2024-02-24 17:16:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-24 17:16:55 0 [Note] Server socket created on IP: '::'.
2024-02-24 17:16:55 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.
"
Dưới đây là mã mysql_error.log e mở ra ở phần Logs ạ
"
2024-02-24 12:44:09 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-02-24 12:44:09 0 [ERROR] Aborting
2024-02-24 17:16:55 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 5948
2024-02-24 17:16:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-02-24 17:16:55 0 [Note] InnoDB: Uses event mutexes
2024-02-24 17:16:55 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-02-24 17:16:55 0 [Note] InnoDB: Number of pools: 1
2024-02-24 17:16:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-02-24 17:16:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-02-24 17:16:55 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-24 17:16:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-02-24 17:16:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-02-24 17:16:55 0 [Note] InnoDB: Setting file 'Cxampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-02-24 17:16:55 0 [Note] InnoDB: File 'Cxampp\mysql\data\ibtmp1' size is now 12 MB.
2024-02-24 17:16:55 0 [Note] InnoDB: Waiting for purge to start
2024-02-24 17:16:55 0 [Note] InnoDB: 10.4.32 started; log sequence number 300333; transaction id 170
2024-02-24 17:16:55 0 [Note] InnoDB: Loading buffer pool(s) from Cxampp\mysql\data\ib_buffer_pool
2024-02-24 17:16:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-02-24 17:16:55 0 [Note] Server socket created on IP: '::'.
2024-02-24 17:16:55 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.
"