USER_PRIVILEGES table provides
information about global privileges. It takes its values from the
mysql.user system table.
USER_PRIVILEGES table has these
The name of the account to which the privilege is granted, in
The name of the catalog. This value is always
The privilege granted. The value can be any privilege that can be granted at the global level; see Section 220.127.116.11, “GRANT Statement”. Each row lists a single privilege, so there is one row per global privilege held by the grantee.
USER_PRIVILEGESis a nonstandard
The following statements are not equivalent:
SELECT ... FROM INFORMATION_SCHEMA.USER_PRIVILEGES SHOW GRANTS ...