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.

Limiting MySQL connections per user

Discussion in 'General Discussion' started by Compila, May 16, 2007.

  1. Compila

    Compila Member
    PartnerNOC

    Joined:
    May 8, 2003
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Hi there

    I appreciate I can set the number of MySQL connections server wide with "set-variable = max_connections=700", however is there any facility within WHM to apply a limit per user? It would be such a handy feature :p

    Alternatively any other suggestions welcome perhaps via a local my.cnf or by setting MAX
    CONNECTIONS option to GRANT

    Thanks
    Nick
     
  2. MN-Robert

    MN-Robert Well-Known Member

    Joined:
    Feb 19, 2003
    Messages:
    203
    Likes Received:
    0
    Trophy Points:
    16
    You should consult the manual from mysql.com for commands.

    However

    max_user_connections=X

    Is what you want
     
Loading...

Share This Page