How to view the user limits like max_queries or max_updates in MySQL?
MySQL 8.0 Reference Manual  /  ...  /  Setting Account Resource Limits (valid for 5.5+ at least).


  The server stores resource limits for an account in the user table row corresponding to the account. The max_questions, max_updates, and max_connections columns store the per-hour limits, and the max_user_connections column stores the MAX_USER_CONNECTIONS limit.


SELECT CONCAT('\'', user, '\'', '@', '\'', host, '\'') account,
       max_questions,
       max_updates,
       max_connections,
       max_user_connections
FROM mysql.user;