Limit number of connections for MySQL user
Posted on October 19, 2009 with No Comments
To limit number of mysql connection per user, edit /etc/my.cnf
vi /etc/my.cnf
In [mysqld] section, set value for max_user_connections.
[mysqld] max_user_connections=40
This will limit mysql connections at a time for any user to 40.
Tags: limit connections, limit mysql usage, mysql
Category: mysql