I have for the first time seen a client implement MySQL Resource Limits. I got the following error tying to connect to the database.
$ mysql -udba -p ERROR 1226 (42000): User 'dba' has exceeded the 'max_user_connections' resource (current value: 10)
I see from the documentation the ability to see the limits in the mysql.user table. I see this is included in the SHOW GRANTS output.
SHOW GRANTS for 'dba'@'%'; +--------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for dba@% | +--------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL …[Read more]