MySQL8.0开放远程连接方法

mysql> use mysql;
Database changed
mysql> update user set host = '%' where user = 'root';
Query OK, 0 rows affected
Rows matched: 1 Changed: 0 Warnings: 0
mysql> grant all privileges on *.* to 'root'@'%'with grant option;
Query OK, 0 rows affected

mysql> flush privileges;
Query OK, 0 rows affected

mysql>