mysql中all privileges包含哪些权限
2016-08-20 10:34 abce 阅读(7906) 评论(0) 编辑 收藏 举报1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | mysql> grant all privileges on test.* to 'ybb' @ '%' identified by 'ybb' ; Query OK, 0 rows affected (0.07 sec) mysql> flush privileges ; Query OK, 0 rows affected (0.00 sec) mysql> select host, user , password from mysql. user where user = 'ybb' and host= '%' ; + -----------+---------+-------------------------------------------+ | host | user | password | + -----------+---------+-------------------------------------------+ | % | ybb | *C85EE1EAA8E69C43CE790C4CFFCF1ED2F88039EB | + -----------+---------+-------------------------------------------+ 1 rows in set (0.00 sec) mysql> show grants for ybb; + ---------------------------------------------------------------------------------------------------+ | Grants for ybb@% | + ---------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'ybb' @ '%' IDENTIFIED BY PASSWORD '*C85EE1EAA8E69C43CE790C4CFFCF1ED2F88039EB' | | GRANT ALL PRIVILEGES ON `test`.* TO 'ybb' @ '%' | + ---------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> revoke insert on test.* from ybb@ '%' ; Query OK, 0 rows affected (0.00 sec) mysql> show grants for ybb; + --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for ybb@% | + --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'ybb' @ '%' IDENTIFIED BY PASSWORD '*C85EE1EAA8E69C43CE790C4CFFCF1ED2F88039EB' | | GRANT SELECT , UPDATE , DELETE , CREATE , DROP , REFERENCES , INDEX , ALTER , CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE , CREATE VIEW , SHOW VIEW , CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `test`.* TO 'ybb' @ '%' | + --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> |
从上可以看出all privileges包含以下权限:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | select , insert , update , delete , create , drop , references , index , alter , create temporary tables, lock tables, execute , create view , show view , create routine, alter routine, event, trigger |
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· .NET10 - 预览版1新功能体验(一)