HostOnNet Blog

Limit number of connections for MySQL user

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.


Posted in MySQL