flush privileges;

mysql> update user set user='root' where host='%';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0


mysql> select host,user from user;
+-------------+------+
| host        | user |
+-------------+------+
| %           | root |
| 127.0.0.1   | root |
| ::1         | root |
| centosnode2 | root |
+-------------+------+
4 rows in set (0.00 sec)


mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)


mysql> update user set password='root' where host='%';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0


mysql> select host,user from user;
+-------------+------+
| host        | user |
+-------------+------+
| %           | root |
| 127.0.0.1   | root |
| ::1         | root |
| centosnode2 | root |
+-------------+------+
4 rows in set (0.00 sec)


mysql> select host,user ,password from user;
+-------------+------+-------------------------------------------+
| host        | user | password                                  |
+-------------+------+-------------------------------------------+
| %           | root | root                                      |
| centosnode2 | root | *E2238AA1A058543BA0CF696A99FB4A6CDAD37B10 |
| 127.0.0.1   | root | *E2238AA1A058543BA0CF696A99FB4A6CDAD37B10 |
| ::1         | root | *E2238AA1A058543BA0CF696A99FB4A6CDAD37B10 |
+-------------+------+-------------------------------------------+
4 rows in set (0.00 sec)


mysql>