mysql8 无法从其他主机访问root用户

mysql版本8.0.36

安装mysql后，输入：

sudo mysql

登录mysql。

使用user数据库：

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 30
Server version: 8.0.36-0ubuntu0.22.04.1 (Ubuntu)

Copyright (c) 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

查看user内的User，Host，plugin三列内容：

mysql> select User,Host,plugin from user;

结果如下：

+------------------+-----------+-----------------------+
| User             | Host      | plugin                |
+------------------+-----------+-----------------------+
| root             | localhost | auth_socket           |
| debian-sys-maint | localhost | caching_sha2_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session    | localhost | caching_sha2_password |
| mysql.sys        | localhost | caching_sha2_password |
+------------------+-----------+-----------------------+

host改为 % ， plugin 改为 ’mysql_native_password‘
（https://zhuanlan.zhihu.com/p/307793416）（https://blog.csdn.net/mazaiting/article/details/106661158）

update user set plugin = 'mysql_native_password' where user = 'root';
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;

再尝试一下即可成功远程使用root登录。