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 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:
    623
    Likes Received:
    6
    Trophy Points:
    18
    Got this from my php script:

    please what/where i need to change in WHM?
     
  2. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,577
    Likes Received:
    40
    Trophy Points:
    48
    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;
     
  3. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    623
    Likes Received:
    6
    Trophy Points:
    18
    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?
     
  4. iserversupport

    iserversupport Well-Known Member

    Joined:
    Nov 4, 2013
    Messages:
    91
    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
     
Loading...

Share This Page