SELECT t.TABLE_SCHEMA

     , t.TABLE_NAME

     , privs.GRANTEE

     , GROUP_CONCAT(privs.PRIVILEGE_TYPE) AS PRIVILEGES

  FROM INFORMATION_SCHEMA.TABLES AS t

  JOIN ( SELECT NULL AS TABLE_SCHEMA

              , NULL AS TABLE_NAME

              , GRANTEE, PRIVILEGE_TYPE

           FROM INFORMATION_SCHEMA.USER_PRIVILEGES

          UNION

         SELECT TABLE_SCHEMA

              , NULL AS TABLE_NAME

              , GRANTEE

              , PRIVILEGE_TYPE

           FROM INFORMATION_SCHEMA.SCHEMA_PRIVILEGES

          UNION

         SELECT TABLE_SCHEMA

              , TABLE_NAME

              , GRANTEE

              , PRIVILEGE_TYPE

           FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES

       ) privs

    ON (t.TABLE_SCHEMA = privs.TABLE_SCHEMA OR privs.TABLE_SCHEMA IS NULL)

   AND (t.TABLE_NAME = privs.TABLE_NAME OR privs.TABLE_NAME IS NULL)

   AND (privs.PRIVILEGE_TYPE <> 'USAGE')

 WHERE t.TABLE_SCHEMA NOT IN ( 'mysql'

                             , 'information_schema'

                             , 'performance_schema'

                             )

 GROUP BY t.TABLE_SCHEMA

        , t.TABLE_NAME

        , privs.GRANTEE

;