Viewing MySQL Account Resource Limits
User resources are store in "mysql.user" table : 

SELECT max_questions, 
       max_updates, 
       max_connections 
FROM   mysql.user 
WHERE  user = 'myuser'
AND    host = '%';


Max.