Default value for max_user_connections on mysql 5.1?

Discussion in 'Site & Server Administration' started by ASTRAPI, Oct 27, 2011.

0
  1. #1
    Hello

    What is the default value for max_user_connections on mysql 5.1?

    How can i set it to unlimited?

    Thank you
     
    ASTRAPI, Oct 27, 2011 IP
  2. supportex

    supportex Peon

    Messages:
    66
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    0
    #2
    supportex, Oct 28, 2011 IP
  3. AnthonyG

    AnthonyG Well-Known Member

    Messages:
    114
    Likes Received:
    3
    Best Answers:
    2
    Trophy Points:
    135
    #3
    Remove max_user_connections from my.cnf then HUP sql, then there is no limit.
     
    AnthonyG, Oct 28, 2011 IP
  4. ASTRAPI

    ASTRAPI Guest

    Messages:
    500
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    What do you mean HUP sql?

    Restart sql?
     
    ASTRAPI, Oct 28, 2011 IP
  5. elicitservers

    elicitservers Peon

    Messages:
    714
    Likes Received:
    7
    Best Answers:
    1
    Trophy Points:
    0
    #5
    elicitservers, Oct 28, 2011 IP
  6. AnthonyG

    AnthonyG Well-Known Member

    Messages:
    114
    Likes Received:
    3
    Best Answers:
    2
    Trophy Points:
    135
    #6
    Yes, that's correct.
     
    AnthonyG, Oct 28, 2011 IP