30.查看MySQL的用户权限-pt-show-grants

最新推荐文章于 2025-06-17 07:09:26 发布

戒掉贪嗔痴

最新推荐文章于 2025-06-17 07:09:26 发布

阅读量232

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库运维-MySQL 文章标签： mysql 数据库

本文链接：https://blog.youkuaiyun.com/weixin_43346403/article/details/129018821

数据库运维-MySQL 专栏收录该内容

207 篇文章

订阅专栏

在MySQL服务器上，使用pt-show-grants工具展示了对于mysql.session和mysql.sys用户的权限设置，包括创建用户、身份验证、权限授予如SELECT,SUPER以及对特定数据库的访问权限。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[root@mysql1 bin]# ./pt-show-grants --socket=/mysql/mysql3306.sock --ask-pass
Enter password: rootroot --输入密码。
-- Grants dumped by pt-show-grants
-- Dumped from server Localhost via UNIX socket, MySQL 5.7.23-log at 2023-02-14 22:03:41
-- Grants for 'mysql.session'@'localhost'
CREATE USER IF NOT EXISTS 'mysql.session'@'localhost';
ALTER USER 'mysql.session'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT LOCK;
GRANT SELECT ON `mysql`.`user` TO 'mysql.session'@'localhost';
GRANT SELECT ON `performance_schema`.* TO 'mysql.session'@'localhost';
GRANT SUPER ON *.* TO 'mysql.session'@'localhost';
-- Grants for 'mysql.sys'@'localhost'
CREATE USER IF NOT EXISTS 'mysql.sys'@'localhost';
ALTER USER 'mysql.sys'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT LOCK;
GRANT SELECT ON `sys`.`sys_config` TO 'mysql.sys'@'localhost';
GRANT TRIGGER ON `sys`.* TO 'mysql.sys'@'localhost';
GRANT USAGE ON *.* TO 'mysql.sys'@'localhost';