Tuesday, June 14, 2016

Set the maximum number of connections on a per user basis

Set the maximum number of connections on a per user basis:

GRANT USAGE ON *.* TO 'myusername'@'127.0.0.1' WITH MAX_USER_CONNECTIONS 10;

Reference:

http://dba.stackexchange.com/questions/35183/mysql-maximum-number-of-connections-on-a-per-user-basis-possible

http://dev.mysql.com/doc/refman/5.7/en/user-resources.html

No comments: