Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Problems with remote mysql: too many connections

Discussion in 'General Discussion' started by cranc2k, Apr 14, 2005.

  1. cranc2k

    cranc2k Registered

    Joined:
    Apr 14, 2005
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    151
    Hello All :)

    This is my first post in this great community !! Sorry for my english.

    I send this topic for problems that I have in my mysql server that I use to use databases in all my servers.

    Today I recive this error in one of my sites:

    Warning: mysql_connect(): Host 'www.HOST.com' is blocked because of

    many connection errors. Unblock with 'mysqladmin flush-hosts'

    Mysql server blocked all conecctions for one of my host for too many connections.

    My question is, I have possibite to put can use more connections or configure mysql to accept ilimitate connections to mysql for all servers?

    I wait responses. Thanks for your help!

    cranc2k.
     
  2. jeroman8

    jeroman8 Well-Known Member

    Joined:
    Mar 14, 2003
    Messages:
    410
    Likes Received:
    0
    Trophy Points:
    166
    Better late than never :)

    You have a mysql config file in /etc/my.cnf
    You can put a lot of stuff in there, just search for it.

    About connections you can set:

    [mysqld]
    max_user_connections = 100
    max_connections = 600

    This is what I have on one server.
    On another server I have max_user set to just 30, it depends on how
    much your individual users need it and how it affect your server and load.

    max_user is the amount of connections a user can have
    max_connections means the amount of connections everybody together can have
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice