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.
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;
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.