宝塔网站服务器管理面板，Ubuntu2204.err 超大文件占用78.75GB空间怎么办 mysql垃圾日志

小樱

宝塔网站服务器管理面板，Ubuntu2204.err 超大文件占用78.75GB空间怎么办 mysql垃圾日志

2025-01-23T16:30:19.826244Z 368601072 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2025-01-23T16:30:19.833421Z 368601073 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2025-01-23T16:30:19.834002Z 368601074 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2025-01-23T16:30:19.835588Z 368601075 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2025-01-23T16:30:19.835908Z 368601076 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

查找资料
https://www.bt.cn/bbs/thread-137991-1-1.html
https://www.bt.cn/bbs/thread-135044-1-1.html

您好 这个是数据库的错误日志 如果您不需要查看的的话 可以执行这条命令进行清理  

1. cat /dev/null > /www/server/data/当前系统主机名.err

复制代码

这个具体需要查看一下数据库有没有错误信息
/www/server/data/目录下的.err文件
帖子上面说看这个文件，里面有什么报错信息导致的err文件产生

看起来1分钟增长10M左右，一天产生15G的垃圾文件，写个计划任务每天清理一次


和宝塔的人反馈下吧，这就不正常


或者网上查了下这个命令，也可以试试去phpmyadmin里面执行sql

1. ALTER USER '数据库用户名'@'localhost' IDENTIFIED WITH caching_sha2_password BY '数据库密码';

复制代码

宝塔带了个有bug的版本给跑生产环境，导致的毛病，这种是环境问题
估计是开发版的mysql，所以会输出这种信息