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:
    66
    Hello

    What is the default value for max_user_connections on mysql 5.1?

    How can i set it to unlimited?

    Thank you
     
    #1 ASTRAPI, Oct 27, 2011
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    15,418
    Likes Received:
    285
    Trophy Points:
    433
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    #2 Infopro, Oct 28, 2011
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,622
    Likes Received:
    24
    Trophy Points:
    238
    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.
     
    #3 cPanelTristan, Nov 1, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - Default value max_user_connections
  1. webstyler

    Plugin issue after cPanel update target default value

    webstyler, Apr 29, 2017, in forum: cPanel Developers
    Replies:
    1
    Views:
    143
    Infopro
    May 1, 2017
  2. rsands2801

    PHP-FPM Default .conf values

    rsands2801, Nov 2, 2016, in forum: EasyApache
    Replies:
    3
    Views:
    322
    cPanelKenneth
    Nov 3, 2016
  3. Spork Schivago

    Changing default umask value for CentOS

    Spork Schivago, Jul 30, 2016, in forum: Security
    Replies:
    3
    Views:
    537
    cPanelMichael
    Aug 2, 2016
  4. stefano_ts

    mysql crash! TIMESTAMP with implicit DEFAULT value is deprecated.

    stefano_ts, Sep 5, 2015, in forum: Database Discussions
    Replies:
    6
    Views:
    9,406
    cPanelMichael
    Dec 16, 2015
  5. Wade John Beckett

    Default Horde preferences.

    Wade John Beckett, Jun 22, 2017 at 1:47 PM, in forum: E-mail Discussions
    Replies:
    1
    Views:
    24
    cPanelMichael
    Jun 22, 2017 at 1:49 PM

Share This Page