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 XY already has more than 'max_user_connections' active connections

Discussion in 'General Discussion' started by postcd, Jul 8, 2014.

  1. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    694
    Likes Received:
    15
    Trophy Points:
    68
    Got this from my php script:

    please what/where i need to change in WHM?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,782
    Likes Received:
    94
    Trophy Points:
    353
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    edit /etc/my.cnf
    add
    max_user_connections = <some number>

    or set per user via MySQL cli

    UPDATE mysql.user SET max_user_connections = xx
    WHERE user='db_user' AND host='localhost';
    FLUSH PRIVILEGES;
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    694
    Likes Received:
    15
    Trophy Points:
    68
    thx, when i have this in my.cnf:
    does it mean i dont need to care about second value, does not relate to the issue?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. iserversupport

    iserversupport Well-Known Member

    Joined:
    Nov 4, 2013
    Messages:
    92
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    India
    cPanel Access Level:
    Root Administrator
    You may have to optimize the MySQL query to use less connection or increase the value max_user_connections
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
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