note 85539 added to function.mysql-connect

From: 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

« previous php.notes (#144144) next »