【待反馈】宝塔mysql每天自动关闭，表被清空
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：9.0.0
系统版本：
centos 7.8
问题描述：
数据库服务每天都会关闭，而且所有的表都没了，已经开启了指定ip访问权限
相关截图（日志、错误）：2024-11-14T02:02:26.331417+08:00 83 Access denied for user ＇root＇@＇45.88.88.47＇ (using password: NO)2024-11-14T02:18:43.106415+08:00 84 IP address ＇83.222.190.78＇ could not be resolved: Name or service not known2024-11-14T02:18:43.106475+08:00 84 Got packets out of order2024-11-14T02:31:32.071003+08:00 85 IP address ＇93.123.39.61＇ could not be resolved: Name or service not known2024-11-14T02:31:32.306031+08:00 85 Access denied for user ＇root＇@＇93.123.39.61＇ (using password: NO)2024-11-14T02:32:07.391715+08:00 87 Access denied for user ＇root＇@＇93.123.39.61＇ (using password: NO)2024-11-14T02:32:52.757225+08:00 0 Giving 1 client threads a chance to die gracefully2024-11-14T02:32:52.757247+08:00 0 Shutting down slave threads2024-11-14T02:32:54.757299+08:00 0 Forcefully disconnecting 1 remaining clients2024-11-14T02:32:54.757321+08:00 0 /www/server/mysql/bin/mysqld: Forcing close of thread 52user: ＇shawn＇2024-11-14T02:32:54.757386+08:00 0 Event Scheduler: Purging the queue. 0 events2024-11-14T02:32:54.757590+08:00 0 Binlog end2024-11-14T02:32:54.760535+08:00 0 Shutting down plugin ＇ngram＇2024-11-14T02:32:54.760550+08:00 0 Shutting down plugin ＇partition＇2024-11-14T02:32:54.760555+08:00 0 Shutting down plugin ＇BLACKHOLE＇2024-11-14T02:32:54.760559+08:00 0 Shutting down plugin ＇ARCHIVE＇2024-11-14T02:32:54.760563+08:00 0 Shutting down plugin ＇PERFORMANCE_SCHEMA＇2024-11-14T02:32:54.760594+08:00 0 Shutting down plugin ＇MRG_MYISAM＇2024-11-14T02:32:54.760599+08:00 0 Shutting down plugin ＇MyISAM＇2024-11-14T02:32:54.760607+08:00 0 Shutting down plugin ＇INNODB_SYS_VIRTUAL＇2024-11-14T02:32:54.760612+08:00 0 Shutting down plugin ＇INNODB_SYS_DATAFILES＇2024-11-14T02:32:54.760615+08:00 0 Shutting down plugin ＇INNODB_SYS_TABLESPACES＇2024-11-14T02:32:54.760619+08:00 0 Shutting down plugin ＇INNODB_SYS_FOREIGN_COLS＇2024-11-14T02:32:54.760623+08:00 0 Shutting down plugin ＇INNODB_SYS_FOREIGN＇2024-11-14T02:32:54.760626+08:00 0 Shutting down plugin ＇INNODB_SYS_FIELDS＇2024-11-14T02:32:54.760630+08:00 0 Shutting down plugin ＇INNODB_SYS_COLUMNS＇2024-11-14T02:32:54.760633+08:00 0 Shutting down plugin ＇INNODB_SYS_INDEXES＇2024-11-14T02:32:54.760637+08:00 0 Shutting down plugin ＇INNODB_SYS_TABLESTATS＇2024-11-14T02:32:54.760640+08:00 0 Shutting down plugin ＇INNODB_SYS_TABLES＇2024-11-14T02:32:54.760644+08:00 0 Shutting down plugin ＇INNODB_FT_INDEX_TABLE＇2024-11-14T02:32:54.760647+08:00 0 Shutting down plugin ＇INNODB_FT_INDEX_CACHE＇2024-11-14T02:32:54.760651+08:00 0 Shutting down plugin ＇INNODB_FT_CONFIG＇2024-11-14T02:32:54.760654+08:00 0 Shutting down plugin ＇INNODB_FT_BEING_DELETED＇2024-11-14T02:32:54.760658+08:00 0 Shutting down plugin ＇INNODB_FT_DELETED＇2024-11-14T02:32:54.760662+08:00 0 Shutting down plugin ＇INNODB_FT_DEFAULT_STOPWORD＇2024-11-14T02:32:54.760666+08:00 0 Shutting down plugin ＇INNODB_METRICS＇2024-11-14T02:32:54.760669+08:00 0 Shutting down plugin ＇INNODB_TEMP_TABLE_INFO＇2024-11-14T02:32:54.760673+08:00 0 Shutting down plugin ＇INNODB_BUFFER_POOL_STATS＇2024-11-14T02:32:54.760676+08:00 0 Shutting down plugin ＇INNODB_BUFFER_PAGE_LRU＇2024-11-14T02:32:54.760680+08:00 0 Shutting down plugin ＇INNODB_BUFFER_PAGE＇2024-11-14T02:32:54.760683+08:00 0 Shutting down plugin ＇INNODB_CMP_PER_INDEX_RESET＇2024-11-14T02:32:54.760687+08:00 0 Shutting down plugin ＇INNODB_CMP_PER_INDEX＇2024-11-14T02:32:54.760691+08:00 0 Shutting down plugin ＇INNODB_CMPMEM_RESET＇2024-11-14T02:32:54.760694+08:00 0 Shutting down plugin ＇INNODB_CMPMEM＇2024-11-14T02:32:54.760698+08:00 0 Shutting down plugin ＇INNODB_CMP_RESET＇2024-11-14T02:32:54.760708+08:00 0 Shutting down plugin ＇INNODB_CMP＇2024-11-14T02:32:54.760711+08:00 0 Shutting down plugin ＇INNODB_LOCK_WAITS＇2024-11-14T02:32:54.760715+08:00 0 Shutting down plugin ＇INNODB_LOCKS＇2024-11-14T02:32:54.760718+08:00 0 Shutting down plugin ＇INNODB_TRX＇2024-11-14T02:32:54.760721+08:00 0 Shutting down plugin ＇InnoDB＇2024-11-14T02:32:54.760755+08:00 0 InnoDB: FTS optimize thread exiting.2024-11-14T02:32:54.760856+08:00 0 InnoDB: Starting shutdown...2024-11-14T02:32:54.860977+08:00 0 InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool2024-11-14T02:32:54.861126+08:00 0 InnoDB: Buffer pool(s) dump completed at 2411142:32:542024-11-14T02:32:56.368866+08:00 0 InnoDB: Shutdown completed; log sequence number 29763222024-11-14T02:32:56.370104+08:00 0 InnoDB: Removed temporary tablespace data file: ＂ibtmp1＂2024-11-14T02:32:56.370116+08:00 0 Shutting down plugin ＇MEMORY＇2024-11-14T02:32:56.370121+08:00 0 Shutting down plugin ＇CSV＇2024-11-14T02:32:56.370124+08:00 0 Shutting down plugin ＇sha256_password＇2024-11-14T02:32:56.370127+08:00 0 Shutting down plugin ＇mysql_native_password＇2024-11-14T02:32:56.370228+08:00 0 Shutting down plugin ＇binlog＇2024-11-14T02:32:56.370857+08:00 0 /www/server/mysql/bin/mysqld: Shutdown complete
端口对外了？ 你好，可咨询我们公司安全运维服务经理，能有效解决当前问题 宝塔用户_aldetf 发表于 2024-11-14 12:22
端口对外了？
啊，可能是的，我放行了默认的3306端口，如果不放行的话，是不是就不能远程连接数据库？ 宝塔用户_lkwcyp 发表于 2024-11-14 18:33
啊，可能是的，我放行了默认的3306端口，如果不放行的话，是不是就不能远程连接数据库？ ...
你可以把权限设置为仅允许指定ip访问
页:
[1]