【已完成】数据库错误日志这个是什么问题
数据库错误日志大量这样的我之前是有用过这个用户名，后来我删除了，系统也重装过了，现在还有这样的错误日志，是什么问题
2024-09-12T02:15:58.612560Z 539 Access denied for user ＇www-hz102-com＇@＇116.30.204.207＇ (using password: YES)
2024-09-12T02:15:59.585465Z 540 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:44 编辑
好的，找到问题了，是我本地电脑连接的 fkenuiabcd 发表于 2024-9-12 12:30
好的，找到问题了，是我本地电脑连接的
好的，您的问题是否得到了解决了呢 运维技术阿闯 发表于 2024-9-12 14:36
好的，您的问题是否得到了解决了呢
刚才那个问题解决了，现在又有一个错误了，是这样的了
2024-09-12T08:42:22.311672Z 31 Access denied for user ＇forge＇@＇localhost＇ (using password: NO) fkenuiabcd 发表于 2024-9-12 16:44
刚才那个问题解决了，现在又有一个错误了，是这样的了
2024-09-12T08:42:22.311672Z 31 Access d ...
这个也是一样的情况，拒绝了这个用户的访问 运维技术阿闯 发表于 2024-9-12 18:20
这个也是一样的情况，拒绝了这个用户的访问
这个都不停的有的，都找不到解决的方法了
2024-09-13T04:12:00.487073Z 14786 Aborted connection 14786 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:00.489509Z 14795 Aborted connection 14795 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.742137Z 14853 Aborted connection 14853 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.746236Z 14851 Aborted connection 14851 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.747736Z 14829 Aborted connection 14829 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.748077Z 14866 Aborted connection 14866 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.758960Z 14865 Aborted connection 14865 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error writing communication packets)
2024-09-13T04:12:14.802921Z 14867 Aborted connection 14867 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:14.826159Z 14864 Aborted connection 14864 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:18.003022Z 14883 Aborted connection 14883 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:18.047854Z 14884 Aborted connection 14884 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:12:18.091160Z 14887 Aborted connection 14887 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:14:20.171432Z 15715 Aborted connection 15715 to db: ＇unconnected＇ user: ＇root＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:14:20.178317Z 15727 Aborted connection 15727 to db: ＇unconnected＇ user: ＇root＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:14:20.180334Z 15728 Aborted connection 15728 to db: ＇unconnected＇ user: ＇root＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:14:20.278845Z 15729 Aborted connection 15729 to db: ＇unconnected＇ user: ＇root＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:06.342179Z 16829 Aborted connection 16829 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:06.348335Z 16876 Aborted connection 16876 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:06.365779Z 16877 Aborted connection 16877 to db: ＇wwwjimutucn＇ user: ＇wwwjimutucn＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:15.729418Z 16945 Aborted connection 16945 to db: ＇wwwjimutucn＇ user: ＇wwwjimutucn＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:15.733164Z 16948 Aborted connection 16948 to db: ＇wwwhz102com＇ user: ＇wwwhz102com＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:15.754842Z 16947 Aborted connection 16947 to db: ＇wwwjimutucn＇ user: ＇wwwjimutucn＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:18.735847Z 16950 Aborted connection 16950 to db: ＇wwwjimutucn＇ user: ＇wwwjimutucn＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:18.765443Z 16972 Aborted connection 16972 to db: ＇wwwjimutucn＇ user: ＇wwwjimutucn＇ host: ＇localhost＇ (Got an error reading communication packets)
2024-09-13T04:17:18.792808Z 16971 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建议不需要所有人访问，调整成本地访问看看，操作前做个快照
页:
[1]