为了能快速了解并处理您的问题，请提供以下基础信息： 面板、插件版本：9.1.0腾讯云专享版、MySQL8.0.36
问题描述：宝塔mysqld服务启动失败,看了一下日志，好像是存在其他MySQL,端口被占用
相关截图（日志、错误）： 2024-11-18T05:46:41.117248Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824. 2024-11-18T05:46:41.117287Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release. 2024-11-18T05:46:41.117351Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2024-11-18T05:46:41.117424Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2024-11-18T05:46:41.117442Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 158306 2024-11-18T05:46:41.128544Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=134217728. Please use innodb_redo_log_capacity instead. 2024-11-18T05:46:41.129964Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-11-18T05:46:41.306903Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-11-18T05:46:41.618678Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2024-11-18T05:46:41.618711Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2024-11-18T05:46:41.619001Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Address already in use 2024-11-18T05:46:41.619010Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ? 2024-11-18T05:46:41.619030Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-11-18T05:46:43.294920Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution. 2024-11-18T05:46:44.162209Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824. 2024-11-18T05:46:44.162250Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release. 2024-11-18T05:46:44.162322Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2024-11-18T05:46:44.162399Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2024-11-18T05:46:44.162419Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 158966 2024-11-18T05:46:44.173009Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=134217728. Please use innodb_redo_log_capacity instead. 2024-11-18T05:46:44.174434Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-11-18T05:46:44.337147Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-11-18T05:46:44.553481Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2024-11-18T05:46:44.553513Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2024-11-18T05:46:44.553768Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Address already in use 2024-11-18T05:46:44.553776Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ? 2024-11-18T05:46:44.553785Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-11-18T05:46:46.146527Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution. 2024-11-18T05:46:51.752698Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824. 2024-11-18T05:46:51.752737Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release. 2024-11-18T05:46:51.752787Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2024-11-18T05:46:51.752856Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2024-11-18T05:46:51.752875Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 159754 2024-11-18T05:46:51.763620Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=134217728. Please use innodb_redo_log_capacity instead. 2024-11-18T05:46:51.765062Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-11-18T05:46:51.995769Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-11-18T05:46:52.263082Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2024-11-18T05:46:52.263115Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2024-11-18T05:46:52.283940Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /tmp/mysqlx.sock 2024-11-18T05:46:52.284037Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.36' socket: '/tmp/mysql.sock' port: 0 Source distribution. 2024-11-18T05:46:56.940196Z 7 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2024-11-18T05:46:56.968578Z 7 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2024-11-18T05:46:56.974486Z 7 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2024-11-18T05:46:56.982482Z 8 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' 2024-11-18T05:46:59.847333Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824. 2024-11-18T05:46:59.847378Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release. 2024-11-18T05:46:59.847436Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2024-11-18T05:46:59.847522Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2024-11-18T05:46:59.847544Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 160849 2024-11-18T05:46:59.865442Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=134217728. Please use innodb_redo_log_capacity instead. 2024-11-18T05:46:59.866989Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-11-18T05:47:02.501180Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824. 2024-11-18T05:47:02.501224Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release. 2024-11-18T05:47:02.501279Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2024-11-18T05:47:02.501372Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead. 2024-11-18T05:47:02.501392Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 161854 2024-11-18T05:47:02.521787Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=134217728. Please use innodb_redo_log_capacity instead. 2024-11-18T05:47:02.523265Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-11-18T05:47:03.621745Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2024-11-18T05:47:03.873886Z 0 [System] [MY-010229] [Server] Starting XA crash recovery... 2024-11-18T05:47:03.886396Z 0 [System] [MY-010232] [Server] XA crash recovery finished. 2024-11-18T05:47:03.942460Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2024-11-18T05:47:03.942532Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2024-11-18T05:47:03.943861Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Address already in use 2024-11-18T05:47:03.943877Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 3306 ? 2024-11-18T05:47:03.943887Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-11-18T05:47:05.456688Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36) Source distribution.
|
|
运维要高效，装宝塔
