MySQL MAX_USER_CONNECTIONS resets to 3 everytime
Hello
One of my websites is giving my the error that MAX_User_connections for user xxxx'@'localhost exceeded (Current value :3). I have done the following command in mysql to increase the max user connections :
The issue will be resolved but it is temporarily and after a couple of days the same error will be back and max_user_connections will be back to 3. I don't what is causing this issue. I have checked the crontab on the server but there is nothing related to this matter. Something is automatically reset the max_user_connections to 3 I have define the mentioned value in my.cnf as bellow : max_connections=1000 max_user_connections=0 Any help would be appreciated.
GRANT USAGE ON *.* TO 'xxxx'@'localhost'
WITH MAX_USER_CONNECTIONS 2;
The issue will be resolved but it is temporarily and after a couple of days the same error will be back and max_user_connections will be back to 3. I don't what is causing this issue. I have checked the crontab on the server but there is nothing related to this matter. Something is automatically reset the max_user_connections to 3 I have define the mentioned value in my.cnf as bellow : max_connections=1000 max_user_connections=0 Any help would be appreciated.
-
Hello :) Which version of MySQL is installed on your system? Is this a standard installation of MySQL? Did you modify the /etc/my.cnf file and then restart MySQL? If so, please post the output of the following command: mysqladmin var | grep max_user
Thank you.0 -
Thank you for your reply I'm using MySQL 5.5 and here is the output of your mentioned command : | max_user_connections | 0 It seems right in the global setting, but I don't why max_user for one specific user is reseting to 3 everytime. Yes it has been a while since I have modified the my.cnf file and mysql service has been restarted several times after that. Is it possible that the user's website codes is adjusting this limit to 3 everytime? 0 -
Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome. Thank you. 0 -
The problem is not present now, it is appearing randomly and we don't know what is the reason. So you cannot exactly check it because it is not happening now. beside I have bought my license from "buycpanel.com" so I cannot send ticket to you from cpanel.net, can I? Is there any other possibility to check from my side? 0 -
You are welcome to open a support ticket with cPanel the next time this happens via: Submit A Ticket It's okay to open a ticket with us even if you purchased the license from a partner, but if they offer support options you may want to explore those first. Thank you. 0
Please sign in to leave a comment.
Comments
5 comments