宝塔官网 IDC推荐 宝塔币商城 邀请大使
█菠萝云买2送1活动！12G内存99元 阿里云国际低折扣多云自助平台 APP分发-无行业限制免审核 A4招租，联系qq394030111 A5招租，联系qq394030111
高防服务器，无视一切流量攻击 【阿里云】宝塔一键部署，低至5折 A8招租，联系qq394030111 【阿里云】宝塔一键部署，低至5折 OV/EV SSL证书，可当日签发
█ 易探云·香港/美国vps仅9元 █ ▶CPS云◀海外大带宽vps服务器 OV/EV SSL证书，可当日签发 【云防护】专注域名和网站安全防护 A15招租，联系qq394030111
当前位置：论坛首页 > Linux面板 > 求助

【已完成】Mysql 8.0.35报错【面板8.0.5】

Always发表在 Linux面板2024-1-17 10:26 [复制链接] 3 2588

为了能快速了解并处理您的问题，请提供以下基础信息：
面板、插件版本：8.0.5
系统版本：Debian11
问题描述：Mysql 8.0.35版本 日志报错

              目前看起来，报错是不影响什么的，可否屏蔽这个报错？？

相关截图（日志、错误）：
  1. 2024-01-16T19:18:32.266314Z 9 [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＇
  2. 2024-01-16T19:18:32.825386Z 10 [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＇
  3. 2024-01-16T19:18:46.161662Z 11 [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＇
  4. 2024-01-16T19:19:04.460745Z 12 [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＇
  5. 2024-01-16T19:19:04.652864Z 13 [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＇
  6. 2024-01-16T19:19:04.655455Z 14 [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＇
  7. 2024-01-16T19:19:04.987920Z 15 [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＇
  8. 2024-01-16T19:19:05.016761Z 16 [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＇
  9. 2024-01-16T19:19:06.540909Z 17 [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＇
  10. 2024-01-16T19:19:06.733165Z 18 [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＇
  11. 2024-01-16T19:19:06.741189Z 19 [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＇
  12. 2024-01-16T19:19:06.741434Z 20 [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＇
  13. 2024-01-16T19:19:06.762504Z 21 [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＇
  14. 2024-01-16T19:19:07.551441Z 22 [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＇
  15. 2024-01-16T19:19:07.802149Z 23 [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＇
  16. 2024-01-16T19:19:07.824561Z 24 [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＇
  17. 2024-01-16T19:19:07.824872Z 25 [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＇
  18. 2024-01-16T19:19:07.840382Z 26 [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＇
  19. 2024-01-16T19:19:14.220366Z 27 [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＇
  20. 2024-01-16T19:19:30.828208Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user ＜via user signal＞. Shutting down mysqld (Version: 8.0.35).
  21. 2024-01-16T19:19:31.379486Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.35)  Source distribution.
  22. 2024-01-16T19:19:32.342707Z 0 [Warning] [MY-000081] [Server] option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.
  23. 2024-01-16T19:19:32.342738Z 0 [Warning] [MY-011070] [Server] ＇binlog_format＇ is deprecated and will be removed in a future release.
  24. 2024-01-16T19:19:32.342786Z 0 [Warning] [MY-010915] [Server] ＇NO_ZERO_DATE＇, ＇NO_ZERO_IN_DATE＇ and ＇ERROR_FOR_DIVISION_BY_ZERO＇ sql modes should be used with strict mode. They will be merged with strict mode in a future release.
  25. 2024-01-16T19:19:32.342846Z 0 [Warning] [MY-010918] [Server] ＇default_authentication_plugin＇ is deprecated and will be removed in a future release. Please use authentication_policy instead.
  26. 2024-01-16T19:19:32.342862Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.35) starting as process 117955
  27. 2024-01-16T19:19:32.369145Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=1073741824. Please use innodb_redo_log_capacity instead.
  28. 2024-01-16T19:19:32.370451Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
  29. 2024-01-16T19:19:32.820877Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
  30. 2024-01-16T19:19:33.008622Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
  31. 2024-01-16T19:19:33.008647Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
  32. 2024-01-16T19:19:33.024092Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: ＇::＇ port: 33060, socket: /tmp/mysqlx.sock
  33. 2024-01-16T19:19:33.024130Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: ＇8.0.35＇  socket: ＇/tmp/mysql.sock＇  port: 3306  Source distribution.
  34. 2024-01-16T19:22:26.795886Z 8 [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＇
  35. 2024-01-16T19:22:27.148953Z 9 [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＇
  36. 2024-01-16T19:22:27.761809Z 10 [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＇
  37. 2024-01-16T19:27:13.011078Z 11 [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＇
  38. 2024-01-16T19:27:13.681678Z 12 [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＇
  39. 2024-01-16T19:29:37.399496Z 13 [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＇
  40. 2024-01-16T19:30:01.442227Z 14 [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＇
  41. 2024-01-16T19:30:01.615943Z 15 [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＇
  42. 2024-01-16T19:30:01.928615Z 16 [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＇
  43. 2024-01-16T19:30:02.124635Z 17 [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＇
  44. 2024-01-16T19:30:03.131691Z 18 [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＇
  45. 2024-01-16T19:30:03.235361Z 19 [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＇
  46. 2024-01-16T19:30:04.187601Z 20 [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＇
  47. 2024-01-16T19:30:04.305259Z 21 [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＇

复制代码


使用道具 举报 只看该作者 回复
阿珂
发表于 2024-1-17 11:35:22 | 显示全部楼层
提示是使用的已经被弃用的加密方式mysql_native_password
可参考一下此贴https://blog.csdn.net/eagle89/article/details/132425831
使用道具 举报 回复 支持 反对
Always
发表于 2024-1-17 19:01:37 | 显示全部楼层
阿珂 发表于 2024-1-17 11:35
提示是使用的已经被弃用的加密方式mysql_native_password
可参考一下此贴https://blog.csdn.net/eagle89/ar ...

发帖前，已经搜索到这个记录了。

但不太像是个好的解决方案。  


BT面板的mysql8默认的加密方式也是 mysql_native_password。

也不是caching_sha2_password




使用道具 举报 回复 支持 反对
阿珂
发表于 2024-4-10 14:34:46 | 显示全部楼层
如果你使用的是caching_sha2_password，可在mysql配置文件中更改参数default_authentication_plugin
如不是，上面日志可忽略，不影响使用
使用道具 举报 回复 支持 反对
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

登录 注册
普通问题处理

论坛响应时间：72小时

问题处理方式：排队(仅解答)

工作时间：白班：9：00 - 18：00

紧急运维服务

响应时间：3分钟

问题处理方式：宝塔专家1对1服务

工作时间：工作日：9：00 - 18：30

宝塔专业团队为您解决服务器疑难问题

点击联系技术免费分析

工作时间：09:00至18:30

  • 联系我们
  • 周一至周六，节假日除外
  • 9:15~12:30，14:00~18:15
  • 联系电话：0769-23030556
  • 如有问题，论坛发帖咨询
  • 商务合作QQ/WX：394030111

《开源许可协议》 | 《用户协议》 | 《隐私声明》 |

高新技术企业编号GR201944000059|粤B2-20201398|粤ICP备17030143号|粤公网安备44190002003211号

Copyright © 2021 宝塔面板|让运维简单高效(www.bt.cn) 广东堡塔安全技术有限公司     Powered by Discuz! X3.4Rights Reserved

违法网站请勿向我司工作人员发起任何形式的人工服务请求，严禁使用宝塔面板从事任何非法活动 | 违规信息举报入口 | 中国互联网举报中心

快速回复 返回顶部 返回列表