MySQL 数据库用户和权限管理
mysql> select User,authentication_string,Host from user; +-----------+-------------------------------------------+-----------+| User | authentication_string | Host |
+-----------+-------------------------------------------+-----------+
| root | *0DB339632B48910F8F0BEF61BD7EAD4441267E6E | localhost |
| mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | localhost |
| accp | *0DB339632B48910F8F0BEF61BD7EAD4441267E6E | localhost |
+-----------+-------------------------------------------+-----------+
3 rows in set (0.00 sec)
#用户列表中只有三个用户此时，做一个用户列表中不存在用户权限
mysql> grant select on ×××表.×××信息 to 'benet'@'localhost'> Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> select User,authentication_string,Host from user;
+-----------+-------------------------------------------+-----------+
| User | authentication_string | Host |
+-----------+-------------------------------------------+-----------+
| root | *0DB339632B48910F8F0BEF61BD7EAD4441267E6E | localhost |
| mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | localhost |
| benet | *E56A114692FE0DE073F9A1DD68A00EEB9703F3F1 | localhost |
| accp | *0DB339632B48910F8F0BEF61BD7EAD4441267E6E | localhost |
+-----------+-------------------------------------------+-----------+
4 rows in set (0.00 sec)
#上面自动创建了benet用户登陆密码为‘123123’
页:
[1]