FreePgs.com Forum

FreePgs Related => Support Requests => Topic started by: mafiareturns on August 10, 2006, 08:27:01 PM

Title: MySQL remote connection
Post by: mafiareturns on August 10, 2006, 08:27:01 PM
Due to the 2000 connections/user/hour limitation, I need to move my mysql database to a remote server. I have the database server working fine ( I am able to connect from my linux command line), but I cannot get the webserver to connect to the database server.  I assume this is because your firewall is blocking outgoing connections on 3306, or because you only allow mysql connections to localhost.  Either way, is it possible I could get this changed? I am planning on switching the entire site over to a different server shortly.
Title: Re: MySQL remote connection
Post by: admin on August 10, 2006, 09:30:57 PM
Your database user should not be limited to 2k connections per hour.  (This limit was only set for a brief period on some accounts while we were having the problems.  This is not a global limit)

You can already connect to remote MySQL servers.  There is nothing in our setup that would block this.

Thank you,
FreePgs.com Admin
Title: Re: MySQL remote connection
Post by: Jrrwizard on August 11, 2006, 03:33:42 AM
Make sure you are changing all your settings correctly.
You may have the wrong host name of the server you are trying to connect to.

The name of the host when it is not "localhost" should be in the format "domain.com"

Hope this helps,
-Jwiz