The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL MAX_USER_CONNECTIONS resets to 3 everytime

Discussion in 'Database Discussions' started by VagrantRonnie, Jan 26, 2014.

  1. VagrantRonnie

    VagrantRonnie Member

    Joined:
    Jun 3, 2013
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    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.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. VagrantRonnie

    VagrantRonnie Member

    Joined:
    Jun 3, 2013
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    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?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  5. VagrantRonnie

    VagrantRonnie Member

    Joined:
    Jun 3, 2013
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    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?
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page