Bug #62229 Plugin Authentication Details are not Integrated with INFORMATION_SCHEMA
Submitted: 22 Aug 2011 21:38 Modified: 19 Nov 2015 17:37
Reporter: Jonathon Coombes Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Pluggable Authentication Severity:S4 (Feature request)
Version:5.5.16 OS:Any
Assigned to: Georgi Kodinov CPU Architecture:Any
Tags: authentication, information_schema, plugin

[22 Aug 2011 21:38] Jonathon Coombes
Details regarding the plugin and authentication string are seen in the mysql.user table, but no corresponding information exists in the INFORMATION_SCHEMA.USER_PRIVILEGES table or any other similar table.

In the same manner, details regarding proxied users can be seen in mysql.proxies_priv table, but nothing similar exists in the INFORMATION_SCHEMA tables.

How to repeat:
mysql> SELECT * FROM mysql.proxies_priv;

compare output with any fields in tables in INFORMATION_SCHEMA. Same can be seen in the mysql.user table.

Suggested fix:
Incorporate the plugin information into the existing INFORMATION_SCHEMA tables, or create a new table, if more appropriate.
[23 Aug 2011 18:11] Peter Gulutzan
Why is this called a bug?
Is there something in our manual,
or our original specification,
that says there will be a table
in information_schema?
[24 Aug 2011 15:23] Georgi Kodinov
Peter is correct. Moving to a feature request.