Bug #74881 Information schema table for user accounts

• Submitted: 16 Nov 2014 11:45
• Modified: 17 Jul 2015 15:04
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: Performance Schema
• Severity: S4 (Feature request)
• Version: 5.7
• OS: Any
• CPU Architecture: Any
• Tags: accounts, grants, list, show grants, users

[16 Nov 2014 11:45] Daniël van Eeden

Description:
Please add a table to information_schema with something similar to:
select user,host,password,plugin,authentication_string,password_expired,ssl_type,ssl_cipher,x509_issuer,x509_subject from mysql.user;

I known there is a USER_PRIVILEGES which show authorization information. I would like to see authentication information.

How to repeat:
See description.

[17 Jul 2015 15:04] Georgi Kodinov

Thank you for the reasonable feature request.