【已完成】数据库错误日志这个是什么问题

数据库错误日志大量这样的

我之前是有用过这个用户名，后来我删除了，系统也重装过了，现在还有这样的错误日志，是什么问题






2024-09-12T02:15:58.612560Z 539 [Note] Access denied for user ＇www-hz102-com＇@＇116.30.204.207＇ (using password: YES)
2024-09-12T02:15:59.585465Z 540 [Note] Access denied for user ＇www-hz102-com＇@＇116.30.204.207＇ (using password: YES)

您弄好，这个提示的是用户www-hz102-com 从IP地址 116.30.204.207 尝试连接，但未能成功，因为它没有适当的权限
如果这个ip是您的话，建议给授权，如果不是您的话，您可能正在遭受到攻击
建议开启防护

好的，找到问题了，是我本地电脑连接的

fkenuiabcd 发表于 2024-9-12 12:30
好的，找到问题了，是我本地电脑连接的

好的，您的问题是否得到了解决了呢

运维技术阿闯 发表于 2024-9-12 14:36
好的，您的问题是否得到了解决了呢

刚才那个问题解决了，现在又有一个错误了，是这样的了

2024-09-12T08:42:22.311672Z 31 [Note] Access denied for user ＇forge＇@＇localhost＇ (using password: NO)

fkenuiabcd 发表于 2024-9-12 16:44
刚才那个问题解决了，现在又有一个错误了，是这样的了

2024-09-12T08:42:22.311672Z 31 [Note] Access d ...

这个也是一样的情况，拒绝了这个用户的访问

运维技术阿闯 发表于 2024-9-12 18:20
这个也是一样的情况，拒绝了这个用户的访问

这个都不停的有的，都找不到解决的方法了


2024-09-13T04:12:00.487073Z 14786 [Note] Aborted connection 14786 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:00.489509Z 14795 [Note] Aborted connection 14795 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.742137Z 14853 [Note] Aborted connection 14853 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.746236Z 14851 [Note] Aborted connection 14851 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.747736Z 14829 [Note] Aborted connection 14829 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.748077Z 14866 [Note] Aborted connection 14866 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.758960Z 14865 [Note] Aborted connection 14865 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error writing communication packets)
2024-09-13T04:12:14.802921Z 14867 [Note] Aborted connection 14867 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.826159Z 14864 [Note] Aborted connection 14864 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:18.003022Z 14883 [Note] Aborted connection 14883 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:18.047854Z 14884 [Note] Aborted connection 14884 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:18.091160Z 14887 [Note] Aborted connection 14887 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:14:20.171432Z 15715 [Note] Aborted connection 15715 to db: ＇unconnected＇ user: ＇root＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:14:20.178317Z 15727 [Note] Aborted connection 15727 to db: ＇unconnected＇ user: ＇root＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:14:20.180334Z 15728 [Note] Aborted connection 15728 to db: ＇unconnected＇ user: ＇root＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:14:20.278845Z 15729 [Note] Aborted connection 15729 to db: ＇unconnected＇ user: ＇root＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:06.342179Z 16829 [Note] Aborted connection 16829 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:06.348335Z 16876 [Note] Aborted connection 16876 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:06.365779Z 16877 [Note] Aborted connection 16877 to db: ＇wwwjimutucn＇ user: ＇wwwjimutucn＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:15.729418Z 16945 [Note] Aborted connection 16945 to db: ＇wwwjimutucn＇ user: ＇wwwjimutucn＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:15.733164Z 16948 [Note] Aborted connection 16948 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:15.754842Z 16947 [Note] Aborted connection 16947 to db: ＇wwwjimutucn＇ user: ＇wwwjimutucn＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:18.735847Z 16950 [Note] Aborted connection 16950 to db: ＇wwwjimutucn＇ user: ＇wwwjimutucn＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:18.765443Z 16972 [Note] Aborted connection 16972 to db: ＇wwwjimutucn＇ user: ＇wwwjimutucn＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:18.792808Z 16971 [Note] Aborted connection 16971 to db: ＇wwwjimutucn＇ user: ＇wwwjimutucn＇ host: ＇localhost＇ (Got an error reading communication packets)

fkenuiabcd 发表于 2024-9-13 12:32
这个都不停的有的，都找不到解决的方法了

您好，您mysqld 的访问权限是不是设置了所有人可以访问呢

运维技术阿闯 发表于 2024-9-13 15:21
您好，您mysqld 的访问权限是不是设置了所有人可以访问呢

是的，要修改吗

fkenuiabcd 发表于 2024-9-13 15:59
是的，要修改吗

mysql建议不需要所有人访问，调整成本地访问看看，操作前做个快照