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

为了能快速了解并处理您的问题，请提供以下基础信息：

面板、插件版本：9.0.0

系统版本：Ubuntu22

问题描述：mysql8.0.35 莫名自动停止，VPS是四核AMD EPYC，12GB内存

相关截图（日志、错误）：

2024-11-12T04:46:58.466282Z 14194 [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-11-12T04:47:02.823167Z 14195 [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-11-12T04:47:04.618352Z 14196 [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-11-12T04:47:07.000342Z 14197 [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-11-12T04:47:09.281580Z 14198 [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-11-12T04:47:12.116813Z 14199 [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-11-12T04:47:12.917322Z 14200 [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-11-12T04:47:16.685568Z 14201 [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＇

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

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

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

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

可以通过查询 MySQL 数据库的用户表（通常是 mysql.user 表）来查看各个用户当前所采用的认证方式
对于那些确定采用 mysql_native_password 认证方式的用户，可以使用 ALTER USER 语句来更新其认证方式为 caching_sha2_password