1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Please help: Error establishing a database connection

Discussion in 'Site & Server Administration' started by abhi786, Jun 7, 2015.

0
  1. #1
    Hello friends,
    I am having error connecting database for my website and when I asked the host support, they suggested below and I don't have any clue on what they are talking about. Please help me.

    Too Many Connections can be caused by either a lot of simultaneous connections or by old connections not being released soon enough. There are some simple changes you can make to your PHP code and your MySQL settings to prevent both.

    Please PM me ...if you are willing to fix the issue...I will pay if needed.

    Thanks.
     
    Last edited: Jun 7, 2015
    abhi786, Jun 7, 2015 IP
  2. billzo

    billzo Well-Known Member

    Messages:
    961
    Likes Received:
    278
    Best Answers:
    15
    Trophy Points:
    113
    #2
    What exactly is your problem? You cannot connect to your database? Or you can connect but are being limited because you have too many connections?

    How much traffic/page views do you have? You may be hitting the limits for shared hosting.
     
    billzo, Jun 7, 2015 IP
  3. TheMostCreative

    TheMostCreative Well-Known Member

    Messages:
    861
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    140
    #3
    Check your db settings(DB user, DB name info in settings).
    If all correct then its your provider who should solve this for you.
     
    TheMostCreative, Jun 8, 2015 IP
  4. HMB Shiraz

    HMB Shiraz Member

    Messages:
    52
    Likes Received:
    8
    Best Answers:
    1
    Trophy Points:
    25
    #4
    The host is suggesting that you are using too many MySQL connections. This can be caused by high traffic or even overloaded servers on the host's end. If you're not experiencing high traffic, the issue could potentially be that your web host has overloaded their servers. You should ask them to take a look, since your settings are correct.

    Alternatively, you may want to migrate to another web host.
     
    HMB Shiraz, Jun 9, 2015 IP
  5. HostPuma

    HostPuma Active Member

    Messages:
    42
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    60
    #5
    Your host is saying that your script might be poorly coded, and has unclosed MySQL connections. Which will eventually lead to "Too Many MySQL Connections".
     
    HostPuma, Jun 21, 2015 IP
  6. The Stealthy One

    The Stealthy One Well-Known Member Affiliate Manager

    Messages:
    3,043
    Likes Received:
    54
    Best Answers:
    0
    Trophy Points:
    105
    #6
    If you have a heavily-trafficked site, it may be time to consider upgrading to a semi-dedicated server or a VPS. It sounds like you are reaching the limits of shared hosting, which I am guessing is what you are currently using?
     
    The Stealthy One, Jun 25, 2015 IP