Warning: mysql_connect(): Too many connections in

Discussion in 'PHP' started by madura99, Oct 19, 2007.

  1. #1
    Warning: mysql_connect(): Too many connections in .....


    I'm getting above error is der nyone to help me??
     
    madura99, Oct 19, 2007 IP
  2. tamen

    tamen Peon

    Messages:
    182
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You have too many connections to you MySQL-server.
     
    tamen, Oct 19, 2007 IP
  3. myharshdesigner

    myharshdesigner Peon

    Messages:
    147
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    just destroy mysql connection after completing your work then you will not prompted by this error.

    thanks
    harsh
     
    myharshdesigner, Oct 19, 2007 IP
  4. myharshdesigner

    myharshdesigner Peon

    Messages:
    147
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    or you can create one file only for mysql connection.and you can import it where that file is required.

    thanks
    harsh
     
    myharshdesigner, Oct 19, 2007 IP
  5. Barti1987

    Barti1987 Well-Known Member

    Messages:
    2,703
    Likes Received:
    115
    Best Answers:
    0
    Trophy Points:
    185
    #5
    This will happen if you have too many visitors on a weak-made MYSQL settings.

    Check your my.cnf (if you have one) file and post it here.

    Peace,
     
    Barti1987, Oct 19, 2007 IP
  6. olddocks

    olddocks Notable Member

    Messages:
    3,275
    Likes Received:
    165
    Best Answers:
    0
    Trophy Points:
    215
    #6
    I think its because of server load. Change your webhost. Probably you are on a shared hosting plan.
     
    olddocks, Oct 19, 2007 IP
  7. SoftCloud

    SoftCloud Well-Known Member

    Messages:
    1,060
    Likes Received:
    28
    Best Answers:
    2
    Trophy Points:
    120
    #7
    This is because your host will only allow you some many MySQL "jobs" to be done in a certain amount of time. Mine allows 50,000 every 30 minutes.

    Make sure you're closing your MySQL stuff.
     
    SoftCloud, Oct 19, 2007 IP