【已完成】Mysql 8.0.35报错【面板8.0.5】
为了能快速了解并处理您的问题，请提供以下基础信息：面板、插件版本：8.0.5系统版本：Debian11
问题描述：Mysql 8.0.35版本 日志报错
目前看起来，报错是不影响什么的，可否屏蔽这个报错？？
相关截图（日志、错误）：
2024-01-16T19:18:32.266314Z 9 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-01-16T19:18:32.825386Z 10 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-01-16T19:18:46.161662Z 11 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-01-16T19:19:04.460745Z 12 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-01-16T19:19:04.652864Z 13 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-01-16T19:19:04.655455Z 14 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-01-16T19:19:04.987920Z 15 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-01-16T19:19:05.016761Z 16 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-01-16T19:19:06.540909Z 17 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-01-16T19:19:06.733165Z 18 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-01-16T19:19:06.741189Z 19 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-01-16T19:19:06.741434Z 20 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-01-16T19:19:06.762504Z 21 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-01-16T19:19:07.551441Z 22 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-01-16T19:19:07.802149Z 23 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-01-16T19:19:07.824561Z 24 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-01-16T19:19:07.824872Z 25 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-01-16T19:19:07.840382Z 26 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-01-16T19:19:14.220366Z 27 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-01-16T19:19:30.828208Z 0 Received SHUTDOWN from user ＜via user signal＞. Shutting down mysqld (Version: 8.0.35).
2024-01-16T19:19:31.379486Z 0 /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.35)Source distribution.
2024-01-16T19:19:32.342707Z 0 option ＇max_allowed_packet＇: unsigned value 107374182400 adjusted to 1073741824.
2024-01-16T19:19:32.342738Z 0 ＇binlog_format＇ is deprecated and will be removed in a future release.
2024-01-16T19:19:32.342786Z 0 ＇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.
2024-01-16T19:19:32.342846Z 0 ＇default_authentication_plugin＇ is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-01-16T19:19:32.342862Z 0 /www/server/mysql/bin/mysqld (mysqld 8.0.35) starting as process 117955
2024-01-16T19:19:32.369145Z 0 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.
2024-01-16T19:19:32.370451Z 1 InnoDB initialization has started.
2024-01-16T19:19:32.820877Z 1 InnoDB initialization has ended.
2024-01-16T19:19:33.008622Z 0 CA certificate ca.pem is self signed.
2024-01-16T19:19:33.008647Z 0 Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-01-16T19:19:33.024092Z 0 X Plugin ready for connections. Bind-address: ＇::＇ port: 33060, socket: /tmp/mysqlx.sock
2024-01-16T19:19:33.024130Z 0 /www/server/mysql/bin/mysqld: ready for connections. Version: ＇8.0.35＇socket: ＇/tmp/mysql.sock＇port: 3306Source distribution.
2024-01-16T19:22:26.795886Z 8 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-01-16T19:22:27.148953Z 9 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-01-16T19:22:27.761809Z 10 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-01-16T19:27:13.011078Z 11 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-01-16T19:27:13.681678Z 12 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-01-16T19:29:37.399496Z 13 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-01-16T19:30:01.442227Z 14 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-01-16T19:30:01.615943Z 15 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-01-16T19:30:01.928615Z 16 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-01-16T19:30:02.124635Z 17 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-01-16T19:30:03.131691Z 18 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-01-16T19:30:03.235361Z 19 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-01-16T19:30:04.187601Z 20 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-01-16T19:30:04.305259Z 21 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
可参考一下此贴https://blog.csdn.net/eagle89/article/details/132425831 阿珂 发表于 2024-1-17 11:35
提示是使用的已经被弃用的加密方式mysql_native_password
可参考一下此贴https://blog.csdn.net/eagle89/ar ...
发帖前，已经搜索到这个记录了。
但不太像是个好的解决方案。
BT面板的mysql8默认的加密方式也是 mysql_native_password。
也不是caching_sha2_password
如果你使用的是caching_sha2_password，可在mysql配置文件中更改参数default_authentication_plugin
如不是，上面日志可忽略，不影响使用
页:
[1]