native连接mysql出错解决办法：

[cfb@fffddd-ddd-3 ~]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 8.0.40 MySQL Community Server - GPL

Copyright © 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select user,host,plugin,authentication_string from user;
±-----------------±----------±----------------------±-----------------------------------------------------------------------+
| user | host | plugin | authentication_string |
±-----------------±----------±----------------------±-----------------------------------------------------------------------+
| admin | % | caching_sha2_password | $A$005$[9*tz~)9JlA^RtsSv2./EZSI7Sys2WZPaEgOGG1/VpAh/3cmxS8pheMs/ |
| mysql.infoschema | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
±-----------------±----------±----------------------±-----------------------------------------------------------------------+
4 rows in set (0.00 sec)

mysql> ALTER USER ‘root’@'%‘IDENTIFIED WITH mysql_native_password BY’admin1234’;
Query OK, 0 rows affected (0.00 sec)

mysql> select user,host,plugin,authentication_string from user;
±-----------------±----------±----------------------±-----------------------------------------------------------------------+
| user | host | plugin | authentication_string |
±-----------------±----------±----------------------±-----------------------------------------------------------------------+
| root | % | mysql_native_password | *7D0061766A72EB68851D957B9291DF4FB1F87B0D |
| mysql.infoschema | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys | localhost | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
±-----------------±----------±----------------------±-----------------------------------------------------------------------+
4 rows in set (0.00 sec)

mysql>

用户名“root” 这种“%”是代表所有可以连接，设置“ mysql_native_password” 代表natice连接 设置’admin1234’数据库登录密码