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.

User 'root' has exceeded the 'max_user_connections' resource

Discussion in 'Database Discussions' started by musioc, Sep 1, 2014.

Thread Status:
Not open for further replies.
  1. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Hello
    Recently I get this error in cpanel and so many features are disabled

    Error Log
    This problem persists even after mysql restart
    Other users has no problem, all sites are OK
    I can not open mysql console Or phpmyadmin

    version:
     
  2. mageshm

    mageshm Well-Known Member

    Joined:
    Apr 17, 2014
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Chennai, INDIA
    cPanel Access Level:
    DataCenter Provider
  3. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Hello
    Yes I have root access
    I think this is not the right way
    Because all other users are running without any problem.

    I should change max_user_connections via mysql console, But I can not run mysql via ssh:
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Try opening /etc/my.cnf and adding or modifying an existing value for:

    max_user_connections

    Then, restart MySQL to ensure the change is enacted.

    Thank you.
     
  5. musioc

    musioc Well-Known Member

    Joined:
    Aug 4, 2011
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Thank you, This not help me
    I was tried
    max_user_connections = 99999
    in my.cnf but no change made (mysql restarted)


    Then I tried to change Mysql version (cloudlinux dbgovernor) and this solved my problem
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I am happy to see the issue is now resolved. Thank you for updating us with the outcome.
     
Loading...
Thread Status:
Not open for further replies.

Share This Page