note 85539 added to function.mysql-connect
| From: | bmagilavy at avalon-internet dot com | Date: | Thu, 04 Sep 2008 20:00:55 +0000 |
| Subject: | note 85539 added to function.mysql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-144144@lists.php.net to get a copy of this message | ||
If you trying to connect to a remote server, here are a few things that can go wrong. Perhaps this
list will save someone some time:
1. You may need to get in touch with the remote server's tech support:
a. to ensure that you can get through its firewall. It is not necessarily enough to have your
server number listed in the recipient site's cpanel remote access host list. It depends on how
the server company has things set up;
b. to find out what port number they are using for database connections, which may not be the
default used by mysql_connect;
c. If you are using ODBC, the host to which you are trying to connect may or may not have any ODBC
drivers installed; and
d. If you are working from a dynamic IP, they may be set up to accommodate it, or you may have to
use a proxy. See http://forge.mysql.com/wiki/MySQL_Proxy .
2. If you are working from a shared server yourself, the server number you were sent in the sign-up
letter is probably NOT the server number you should be using to connect to a remote database. You
need the server number of the machine on which your site is sitting, not your virtual account server
number on that machine. You can get this from your own tech support.
I am grateful to Jonathan Jones at Bluehost for this analysis.
----
Server IP: 64.71.164.2
Probable Submitter: 68.127.106.55
----
Manual Page -- http://www.php.net/manual/en/function.mysql-connect.php
Edit -- https://master.php.net/note/edit/85539
Del: integrated -- https://master.php.net/note/delete/85539/integrated
Del: useless -- https://master.php.net/note/delete/85539/useless
Del: bad code -- https://master.php.net/note/delete/85539/bad+code
Del: spam -- https://master.php.net/note/delete/85539/spam
Del: non-english -- https://master.php.net/note/delete/85539/non-english
Del: in docs -- https://master.php.net/note/delete/85539/in+docs
Del: other reasons-- https://master.php.net/note/delete/85539
Reject -- https://master.php.net/note/reject/85539
Search -- https://master.php.net/manage/user-notes.php