宝塔用户_teqpot 发表于 2024-11-12 14:15:37

【待反馈】mysql8.0.35 莫名自动停止

为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：9.0.0
系统版本：Ubuntu22
问题描述：mysql8.0.35 莫名自动停止，VPS是四核AMD EPYC，12GB内存
相关截图（日志、错误）：2024-11-12T04:46:58.466282Z 14194 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-11-12T04:47:02.823167Z 14195 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-11-12T04:47:04.618352Z 14196 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-11-12T04:47:07.000342Z 14197 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-11-12T04:47:09.281580Z 14198 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-11-12T04:47:12.116813Z 14199 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-11-12T04:47:12.917322Z 14200 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-11-12T04:47:16.685568Z 14201 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-11-12 18:24:12

您好，从日志来看是关于mysql_native_password插件的警告
mysql_native_password插件已经被标记为废弃状态，并且在未来的某个 MySQL 版本发布时将会被移除，同时建议使用caching_sha2_password插件来替代它

宝塔用户_cjeorf 发表于 2024-11-13 14:02:34

堡塔运维南一 发表于 2024-11-12 18:24
您好，从日志来看是关于mysql_native_password插件的警告
mysql_native_password插件已经被标记为废弃状态 ...

解决方案呢？只知道照本宣科？

堡塔运维南一 发表于 2024-11-14 10:27:18

宝塔用户_cjeorf 发表于 2024-11-13 14:02
解决方案呢？只知道照本宣科？

可以通过查询 MySQL 数据库的用户表（通常是 mysql.user 表）来查看各个用户当前所采用的认证方式
对于那些确定采用 mysql_native_password 认证方式的用户，可以使用 ALTER USER 语句来更新其认证方式为 caching_sha2_password
页: [1]
查看完整版本: 【待反馈】mysql8.0.35 莫名自动停止