查询用户
mysql> select user,host ,authentication_string from mysql.user;
+---------------+-----------+-------------------------------------------+
| user | host | authentication_string |
+---------------+-----------+-------------------------------------------+
| root | localhost | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| mysql.session | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
+---------------+-----------+-------------------------------------------+
创建用户
mysql> create user wy@'10.0.0.%' identified by '123456';
mysql> create user wy@'localhost' identified by '123456';
删除用户
mysql> drop user wy@'localhost';
修改用户密码
mysql> alter user wy@'10.0.0.%' identified by '123456';