Linux从入门到放弃 MySQL用户管理

查询用户

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';