MySQL MAX_USER_CONNECTIONS resets to 3 everytime

VagrantRonnie

Member
Jun 3, 2013
6
0
1
cPanel Access Level
Root Administrator
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 :
Code:
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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:

Code:
mysqladmin var | grep max_user
Thank you.
 

VagrantRonnie

Member
Jun 3, 2013
6
0
1
cPanel Access Level
Root Administrator
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?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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.
 

VagrantRonnie

Member
Jun 3, 2013
6
0
1
cPanel Access Level
Root Administrator
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?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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.