mysql> select user,plugin,host from user where user ='root';
+------+-----------------------+------+
| user | plugin | host |
+------+-----------------------+------+
| root | caching_sha2_password | % |
+------+-----------------------+------+
mysql> alter user root@'%' IDENTIFIED BY 'Huwei' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)
mysql> alter user root@'%' IDENTIFIED WITH mysql_native_password BY 'Huawei@169' ;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)