mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘YUzi@12345’;
Query OK, 0 rows affected (0.05 sec)
mysql> CREATE USER ‘YUzi’@’%’ IDENTIFIED WITH mysql_native_password BY ‘YUzi@12345@#’
-> ;
Query OK, 0 rows affected (0.07 sec)
mysql> select user,host,authentication_string from mysql.user;
±-----------------±----------±------------------------------------------+
| user | host | authentication_string |
±-----------------±----------±------------------------------------------+
| YUzi | % | *AA6C8C4CDEA224A8E43375EB361C919C0B007F95 |
| mysql.infoschema | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.session | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| root | localhost | *7ADB49841DBD467A82228C609174F51985A1AB4A |
±-----------------±----------±------------------------------------------+
5 rows in set (0.00 sec)
mysql>