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 from user where user = 'root';
+------+-----------+
| user | host      |
+------+-----------+
| root | localhost |
+------+-----------+

mysql> update mysql.user set host='%' where user='root';

mysql> select user, host from user where user = 'root';
+------+------+
| user | host |
+------+------+
| root | %    |
+------+------+
1 row in set (0.00 sec)

mysql> flush privileges;

[zhangsan @node01 /]$ sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

mysql> quit
[zhangsan @node01 /]$ sudo systemctl restart mysqld