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.

Default value for max_user_connections on mysql 5.1?

Discussion in 'Database Discussions' started by ASTRAPI, Oct 27, 2011.

  1. ASTRAPI

    ASTRAPI Well-Known Member

    Joined:
    Jul 8, 2008
    Messages:
    321
    Likes Received:
    0
    Trophy Points:
    16
    Hello

    What is the default value for max_user_connections on mysql 5.1?

    How can i set it to unlimited?

    Thank you
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,456
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    You can check the default for any variable by running the following command in root SSH:

    Code:
    mysqladmin var | grep variablename
    Replacing variablename with the name of the variable. For example, if you run this command:

    Code:
    root@host [/]# mysqladmin var | grep max_user
    | max_user_connections                    | 0 
    0 here means unlimited. Of note, this only works if you have not already set the variable in /etc/my.cnf file. If you have, take out the variable or comment it out in /etc/my.cnf and restart MySQL to see the default for the variable.
     
Loading...

Share This Page