mysql用户授权操作
mysql> use mysql ; #zhaoyun用户对mysql数据库没有任何权限。 ERROR 1044 (42000): Access denied for user 'zhaoyun'@'localhost' to database 'mysql'mysql>
mysql> use zhaoyun ;#可以使用zhaoyun数据库
Database changed
mysql> show grants ; #查看当前用户拥有的权限
+--------------------------------------------------------------------------------------+
| Grants for zhaoyun@localhost |
+--------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'zhaoyun'@'localhost' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON `zhaoyun`.* TO 'zhaoyun'@'localhost' |
+--------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> create table test(user char(3)); #建表测试
Query OK, 0 rows affected (0.00 sec)
页:
[1]