HostOnNet Blog

Limit number of connections for MySQL user

Looking for Linux Server Admin or WordPress Expert? We can help.

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.