小樱 发表于 2025/1/24 00:27

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

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





2025-01-23T16:30:19.826244Z 368601072 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 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 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 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 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

您好 这个是数据库的错误日志 如果您不需要查看的的话 可以执行这条命令进行清理
cat /dev/null > /www/server/data/当前系统主机名.err
这个具体需要查看一下数据库有没有错误信息
/www/server/data/目录下的.err文件
帖子上面说看这个文件,里面有什么报错信息导致的err文件产生

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


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


或者网上查了下这个命令,也可以试试去phpmyadmin里面执行sql
ALTER USER '数据库用户名'@'localhost' IDENTIFIED WITH caching_sha2_password BY '数据库密码';

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

页: [1]
查看完整版本: 宝塔网站服务器管理面板,Ubuntu2204.err 超大文件占用78.75GB空间怎么办 mysql垃圾日志