【待反馈】宝塔mysql每天自动关闭，表被清空

为了能快速了解并处理您的问题，请提供以下基础信息：

面板、插件版本：

9.0.0

系统版本：

centos 7.8

问题描述：

数据库服务每天都会关闭，而且所有的表都没了，已经开启了指定ip访问权限

相关截图（日志、错误）：

2024-11-14T02:02:26.331417+08:00 83 [Note] Access denied for user ＇root＇@＇45.88.88.47＇ (using password: NO)

2024-11-14T02:18:43.106415+08:00 84 [Warning] IP address ＇83.222.190.78＇ could not be resolved: Name or service not known

2024-11-14T02:18:43.106475+08:00 84 [Note] Got packets out of order

2024-11-14T02:31:32.071003+08:00 85 [Warning] IP address ＇93.123.39.61＇ could not be resolved: Name or service not known

2024-11-14T02:31:32.306031+08:00 85 [Note] Access denied for user ＇root＇@＇93.123.39.61＇ (using password: NO)

2024-11-14T02:32:07.391715+08:00 87 [Note] Access denied for user ＇root＇@＇93.123.39.61＇ (using password: NO)

2024-11-14T02:32:52.757225+08:00 0 [Note] Giving 1 client threads a chance to die gracefully

2024-11-14T02:32:52.757247+08:00 0 [Note] Shutting down slave threads

2024-11-14T02:32:54.757299+08:00 0 [Note] Forcefully disconnecting 1 remaining clients

2024-11-14T02:32:54.757321+08:00 0 [Warning] /www/server/mysql/bin/mysqld: Forcing close of thread 52  user: ＇shawn＇

2024-11-14T02:32:54.757386+08:00 0 [Note] Event Scheduler: Purging the queue. 0 events

2024-11-14T02:32:54.757590+08:00 0 [Note] Binlog end

2024-11-14T02:32:54.760535+08:00 0 [Note] Shutting down plugin ＇ngram＇

2024-11-14T02:32:54.760550+08:00 0 [Note] Shutting down plugin ＇partition＇

2024-11-14T02:32:54.760555+08:00 0 [Note] Shutting down plugin ＇BLACKHOLE＇

2024-11-14T02:32:54.760559+08:00 0 [Note] Shutting down plugin ＇ARCHIVE＇

2024-11-14T02:32:54.760563+08:00 0 [Note] Shutting down plugin ＇PERFORMANCE_SCHEMA＇

2024-11-14T02:32:54.760594+08:00 0 [Note] Shutting down plugin ＇MRG_MYISAM＇

2024-11-14T02:32:54.760599+08:00 0 [Note] Shutting down plugin ＇MyISAM＇

2024-11-14T02:32:54.760607+08:00 0 [Note] Shutting down plugin ＇INNODB_SYS_VIRTUAL＇

2024-11-14T02:32:54.760612+08:00 0 [Note] Shutting down plugin ＇INNODB_SYS_DATAFILES＇

2024-11-14T02:32:54.760615+08:00 0 [Note] Shutting down plugin ＇INNODB_SYS_TABLESPACES＇

2024-11-14T02:32:54.760619+08:00 0 [Note] Shutting down plugin ＇INNODB_SYS_FOREIGN_COLS＇

2024-11-14T02:32:54.760623+08:00 0 [Note] Shutting down plugin ＇INNODB_SYS_FOREIGN＇

2024-11-14T02:32:54.760626+08:00 0 [Note] Shutting down plugin ＇INNODB_SYS_FIELDS＇

2024-11-14T02:32:54.760630+08:00 0 [Note] Shutting down plugin ＇INNODB_SYS_COLUMNS＇

2024-11-14T02:32:54.760633+08:00 0 [Note] Shutting down plugin ＇INNODB_SYS_INDEXES＇

2024-11-14T02:32:54.760637+08:00 0 [Note] Shutting down plugin ＇INNODB_SYS_TABLESTATS＇

2024-11-14T02:32:54.760640+08:00 0 [Note] Shutting down plugin ＇INNODB_SYS_TABLES＇

2024-11-14T02:32:54.760644+08:00 0 [Note] Shutting down plugin ＇INNODB_FT_INDEX_TABLE＇

2024-11-14T02:32:54.760647+08:00 0 [Note] Shutting down plugin ＇INNODB_FT_INDEX_CACHE＇

2024-11-14T02:32:54.760651+08:00 0 [Note] Shutting down plugin ＇INNODB_FT_CONFIG＇

2024-11-14T02:32:54.760654+08:00 0 [Note] Shutting down plugin ＇INNODB_FT_BEING_DELETED＇

2024-11-14T02:32:54.760658+08:00 0 [Note] Shutting down plugin ＇INNODB_FT_DELETED＇

2024-11-14T02:32:54.760662+08:00 0 [Note] Shutting down plugin ＇INNODB_FT_DEFAULT_STOPWORD＇

2024-11-14T02:32:54.760666+08:00 0 [Note] Shutting down plugin ＇INNODB_METRICS＇

2024-11-14T02:32:54.760669+08:00 0 [Note] Shutting down plugin ＇INNODB_TEMP_TABLE_INFO＇

2024-11-14T02:32:54.760673+08:00 0 [Note] Shutting down plugin ＇INNODB_BUFFER_POOL_STATS＇

2024-11-14T02:32:54.760676+08:00 0 [Note] Shutting down plugin ＇INNODB_BUFFER_PAGE_LRU＇

2024-11-14T02:32:54.760680+08:00 0 [Note] Shutting down plugin ＇INNODB_BUFFER_PAGE＇

2024-11-14T02:32:54.760683+08:00 0 [Note] Shutting down plugin ＇INNODB_CMP_PER_INDEX_RESET＇

2024-11-14T02:32:54.760687+08:00 0 [Note] Shutting down plugin ＇INNODB_CMP_PER_INDEX＇

2024-11-14T02:32:54.760691+08:00 0 [Note] Shutting down plugin ＇INNODB_CMPMEM_RESET＇

2024-11-14T02:32:54.760694+08:00 0 [Note] Shutting down plugin ＇INNODB_CMPMEM＇

2024-11-14T02:32:54.760698+08:00 0 [Note] Shutting down plugin ＇INNODB_CMP_RESET＇

2024-11-14T02:32:54.760708+08:00 0 [Note] Shutting down plugin ＇INNODB_CMP＇

2024-11-14T02:32:54.760711+08:00 0 [Note] Shutting down plugin ＇INNODB_LOCK_WAITS＇

2024-11-14T02:32:54.760715+08:00 0 [Note] Shutting down plugin ＇INNODB_LOCKS＇

2024-11-14T02:32:54.760718+08:00 0 [Note] Shutting down plugin ＇INNODB_TRX＇

2024-11-14T02:32:54.760721+08:00 0 [Note] Shutting down plugin ＇InnoDB＇

2024-11-14T02:32:54.760755+08:00 0 [Note] InnoDB: FTS optimize thread exiting.

2024-11-14T02:32:54.760856+08:00 0 [Note] InnoDB: Starting shutdown...

2024-11-14T02:32:54.860977+08:00 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool

2024-11-14T02:32:54.861126+08:00 0 [Note] InnoDB: Buffer pool(s) dump completed at 241114  2:32:54

2024-11-14T02:32:56.368866+08:00 0 [Note] InnoDB: Shutdown completed; log sequence number 2976322

2024-11-14T02:32:56.370104+08:00 0 [Note] InnoDB: Removed temporary tablespace data file: ＂ibtmp1＂

2024-11-14T02:32:56.370116+08:00 0 [Note] Shutting down plugin ＇MEMORY＇

2024-11-14T02:32:56.370121+08:00 0 [Note] Shutting down plugin ＇CSV＇

2024-11-14T02:32:56.370124+08:00 0 [Note] Shutting down plugin ＇sha256_password＇

2024-11-14T02:32:56.370127+08:00 0 [Note] Shutting down plugin ＇mysql_native_password＇

2024-11-14T02:32:56.370228+08:00 0 [Note] Shutting down plugin ＇binlog＇

2024-11-14T02:32:56.370857+08:00 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

端口对外了？

你好，可咨询我们公司安全运维服务经理，能有效解决当前问题

宝塔用户_aldetf 发表于 2024-11-14 12:22
端口对外了？

啊，可能是的，我放行了默认的3306端口，如果不放行的话，是不是就不能远程连接数据库？