How to update MySQL max_user_connections per user in VPS or dedicated server

How to update MySQL max_user_connections per user in VPS or dedicated server

In many situation when you need to add more connections at same time to your database. It allows the 30 connection by default. If you want to modify the limit of max_user_connections follow the following steps.

Steps to modify the limit of max_user_connections in VPS Server:

Step 1: login to server through SSH.

Step 2: go into folder /etc.

Step 3: open the my.cnf file for modifying.

Step 4: you can see the setting

Max_user_connections=30

Step 5: then you can change the limit of connections in the setting.

Max_user_connections=50

Step 6: close the editor and click on save button to save the changes.

Advantages of max_user_connections:

With the help of setting the max user connection you may reduce the possible single user account that impacts negatively of your site on your server. This feature is more useful for shared hosting server where you have no control on the traffic. This is also help to handle maximum traffic on the website when search bots generates. When you setting the max_user_connections then it also helps in many situation such as when search bots hits several pages then most connections are spike.
Author
Jaishree
Views
1,983
First release
Last update
Rating
0.00 star(s) 0 ratings
Top