Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

User 'root' has exceeded the 'max_user_connections' resource

Discussion in 'General Discussion' started by Judd Taylor, Oct 7, 2014.

  1. Judd Taylor

    Judd Taylor Member

    Joined:
    Aug 4, 2014
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Melbourne, Victoria, Australia, Australia
    cPanel Access Level:
    Root Administrator
    Hi,

    Running WHM 11.44.1 (build 18) with Cloudlinux 6.5 x86_64

    In the last few days have been unable to run many features within WHM.

    For example clicking "Restores a Full Backup / cpmove File" within WHM gives the error:

    Cpanel::DBI::Mysql connect('','root',...) failed: User 'root' has exceeded the 'max_user_connections' resource (current value: -1) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 136


    The error is consistent for other WHM features which involve MySQL. ie always User 'root' has exceeded the 'max_user_connections' resource (current value: -1)

    Two recent changes have been:
    - applying updates to ensure the server is doing an update due to the ShellShock vulnerability
    - adding new IP and SSL certificate

    In an attempt to resolve the issue I've modified /etc/my.cnf and added the line max_user_connections = 5000

    This had no effect
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,532
    Likes Received:
    1,966
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    I've seen this reported after failed MySQL upgrades. In those cases, the resolution was to restart MySQL with skip-grant-tables, run "mysql_upgrade -s" to upgrade the system tables, and then restart MySQL without skip-grant-tables.

    Could you let us know if these steps help?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Judd Taylor

    Judd Taylor Member

    Joined:
    Aug 4, 2014
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Melbourne, Victoria, Australia, Australia
    cPanel Access Level:
    Root Administrator
    Thank you for the quick suggestion.

    Not having much luck

    Via PuTTY I attempted:
    mysql skip-grant-tables

    Reply was a similar error:
    ERROR 1226 (42000): User 'root' has exceeded the 'max_user_connections' resource (current value: -1)
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,532
    Likes Received:
    1,966
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    If restarting MySQL before starting that workaround does not help, then 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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Judd Taylor

    Judd Taylor Member

    Joined:
    Aug 4, 2014
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Melbourne, Victoria, Australia, Australia
    cPanel Access Level:
    Root Administrator
    Ticket 5577731
     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,532
    Likes Received:
    1,966
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    To update, the user was able to resolve the issue through the use of the "mysql_upgrade" command.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. Judd Taylor

    Judd Taylor Member

    Joined:
    Aug 4, 2014
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Melbourne, Victoria, Australia, Australia
    cPanel Access Level:
    Root Administrator
    A little more info for any who encounter similar issues...

    Appears my issue was that my MySQL installation had become corrupted during a failed MySQL update.

    In the end I was able to resolve the issue by following the instructions from MySQL Governor > Backing Up MySQL by running the following commands:

    $ mkdir -p ~/mysqlbkp
    $ service mysql restart --skip-networking --skip-grant-tables
    $ mysql_upgrade
    $ mysqldump --all-databases --routines --triggers > ~/mysqlbkp/dbcopy.sql
    $ service mysql stop
    $ cp -r /var/lib/mysql/mysql ~/mysqlbkp/
    $ service mysql start
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice