GRANT USAGE ON *.* TO 'zjzc_zyj'@'%' identified by '1234567';
GRANT SELECT ON `zjzc`.* TO 'zjzc_zyj'@'%';
mysql> create table a100(id int);
ERROR 1142 (42000): CREATE command denied to user 'zjzc_zyj'@'localhost' for table 'a100'
mysql> delete from ActivityInfo;
ERROR 1142 (42000): DELETE command denied to user 'zjzc_zyj'@'localhost' for table 'ActivityInfo'
mysql> show grants for zjzc_zyj@'%';
+--------------------------------------------+
| Grants for zjzc_zyj@% |
+--------------------------------------------+
| GRANT USAGE ON *.* TO 'zjzc_zyj'@'%' |
| GRANT SELECT ON `zjzc`.* TO 'zjzc_zyj'@'%' |
+--------------------------------------------+
2 rows in set (0.00 sec)
mysql>
Mysql 创建查询用户
最新推荐文章于 2024-07-19 03:23:24 发布
本文介绍了如何在MySQL中创建并授予用户权限。通过GRANT命令,赋予了用户'zjzc_zyj'全局使用权限及对'zjzc'数据库的SELECT权限。然而,用户在尝试创建表和删除数据时遇到了权限被拒绝的问题,展示了MySQL的权限控制机制。
摘要由CSDN通过智能技术生成