【待反馈】宝塔mysqld服务启动失败
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：9.1.0腾讯云专享版、MySQL8.0.36系统版本：OpenCloudOS 9
问题描述：宝塔mysqld服务启动失败,看了一下日志，好像是存在其他MySQL,端口被占用
相关截图（日志、错误）： 2024-11-18T05:46:41.117248Z 0 option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.2024-11-18T05:46:41.117287Z 0 'binlog_format' is deprecated and will be removed in a future release.2024-11-18T05:46:41.117351Z 0 '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 '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 /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 1583062024-11-18T05:46:41.128544Z 0 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 InnoDB initialization has started.2024-11-18T05:46:41.306903Z 1 InnoDB initialization has ended.2024-11-18T05:46:41.618678Z 0 CA certificate ca.pem is self signed.2024-11-18T05:46:41.618711Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-11-18T05:46:41.619001Z 0 Can't start server: Bind on TCP/IP port: Address already in use2024-11-18T05:46:41.619010Z 0 Do you already have another mysqld server running on port: 3306 ?2024-11-18T05:46:41.619030Z 0 Aborting2024-11-18T05:46:43.294920Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36)Source distribution.2024-11-18T05:46:44.162209Z 0 option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.2024-11-18T05:46:44.162250Z 0 'binlog_format' is deprecated and will be removed in a future release.2024-11-18T05:46:44.162322Z 0 '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 '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 /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 1589662024-11-18T05:46:44.173009Z 0 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 InnoDB initialization has started.2024-11-18T05:46:44.337147Z 1 InnoDB initialization has ended.2024-11-18T05:46:44.553481Z 0 CA certificate ca.pem is self signed.2024-11-18T05:46:44.553513Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-11-18T05:46:44.553768Z 0 Can't start server: Bind on TCP/IP port: Address already in use2024-11-18T05:46:44.553776Z 0 Do you already have another mysqld server running on port: 3306 ?2024-11-18T05:46:44.553785Z 0 Aborting2024-11-18T05:46:46.146527Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36)Source distribution.2024-11-18T05:46:51.752698Z 0 option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.2024-11-18T05:46:51.752737Z 0 'binlog_format' is deprecated and will be removed in a future release.2024-11-18T05:46:51.752787Z 0 '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 '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 /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 1597542024-11-18T05:46:51.763620Z 0 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 InnoDB initialization has started.2024-11-18T05:46:51.995769Z 1 InnoDB initialization has ended.2024-11-18T05:46:52.263082Z 0 CA certificate ca.pem is self signed.2024-11-18T05:46:52.263115Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-11-18T05:46:52.283940Z 0 X Plugin ready for connections. Socket: /tmp/mysqlx.sock2024-11-18T05:46:52.284037Z 0 /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.36'socket: '/tmp/mysql.sock'port: 0Source distribution.2024-11-18T05:46:56.940196Z 7 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 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 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 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 option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.2024-11-18T05:46:59.847378Z 0 'binlog_format' is deprecated and will be removed in a future release.2024-11-18T05:46:59.847436Z 0 '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 '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 /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 1608492024-11-18T05:46:59.865442Z 0 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 InnoDB initialization has started.2024-11-18T05:47:02.501180Z 0 option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.2024-11-18T05:47:02.501224Z 0 'binlog_format' is deprecated and will be removed in a future release.2024-11-18T05:47:02.501279Z 0 '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 '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 /www/server/mysql/bin/mysqld (mysqld 8.0.36) starting as process 1618542024-11-18T05:47:02.521787Z 0 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 InnoDB initialization has started.2024-11-18T05:47:03.621745Z 1 InnoDB initialization has ended.2024-11-18T05:47:03.873886Z 0 Starting XA crash recovery...2024-11-18T05:47:03.886396Z 0 XA crash recovery finished.2024-11-18T05:47:03.942460Z 0 CA certificate ca.pem is self signed.2024-11-18T05:47:03.942532Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.2024-11-18T05:47:03.943861Z 0 Can't start server: Bind on TCP/IP port: Address already in use2024-11-18T05:47:03.943877Z 0 Do you already have another mysqld server running on port: 3306 ?2024-11-18T05:47:03.943887Z 0 Aborting2024-11-18T05:47:05.456688Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.36)Source distribution.
https://cdn.jsdelivr.net/gh/jhzhou002/blogImage@main/image/image-20241118150145861.png https://cdn.jsdelivr.net/gh/jhzhou002/blogImage@main/image/image-20241118150251433.png 您好，主要原因是因为端口被占用了，执行下面命令查看一下是什么进程占用的
netstat -ntlp | grep 3306
页:
[1]