pt-show-grants does not support IDENTIFIED WITH for authentication plugins
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
In Progress
|
Undecided
|
Frank Cizmich |
Bug Description
mysql> CREATE USER test_user IDENTIFIED WITH auth_pam AS 'mysql';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL ON test.* TO test_user;
Query OK, 0 rows affected (0.02 sec)
The information about the authentication plugin is missing from the output.
$ pt-show-grants -uroot --ask | grep test_user
-- Grants for 'test_user'@'%'
GRANT ALL PRIVILEGES ON `test`.* TO 'test_user'@'%';
GRANT USAGE ON *.* TO 'test_user'@'%';
mysql> SELECT * FROM mysql.user WHERE User='test_user'\G
*******
Create_
Lock_
Repl_
Create_
Create_
Alter_
Create_
Create_
max_user_
authentication
1 row in set (0.00 sec)
Changed in percona-toolkit: | |
status: | Confirmed → In Progress |
assignee: | nobody → Frank Cizmich (frank-cizmich) |
tags: | added: pt-show-grants |
5.5.35-33.0-log Percona Server (GPL), Release rel33.0, Revision 611
pt-show-grants 2.2.7