mysql all privileges_mysql中all privileges包含哪些权限

作者：木道寻08 | 2024-06-22 00:44:11

踩

all privileges

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包含以下权限：

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

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/木道寻08/article/detail/744752