note 35158 deleted from function.mysql-connect by nlopess

From: Date: Sun, 07 Mar 2004 11:04:18 +0000
Subject: note 35158 deleted from function.mysql-connect by nlopess
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-66384@lists.php.net to get a copy of this message
Note Submitter: al@algorythm.ca ---- For those of you looking to connect to an external mySQL server, for instance to save your client some outrageous charge every month with their current host, this might save you a headache, not to mention the rest of your day... You will have to modify the Hosts Allow on the mySQL of the external server to allow the connection from your other site. phpMyAdmin has a textfield for this, or simply contact your administrator. Anyways, lets say you are connecting from the site yoursite.com, simply adding yoursite.com or y.o.ur.IP to the Hosts Allow may not work. You could get an error like: > Warning: mysql_connect(): Access denied for user: 'yourUser@someOtherSite.com' < All you need to do is add the someOtherSite.com to the Hosts Allow and your all set ... that is to say, you may need to force this error in order to Allow the right host, especially with all the resellers in resellers these days. ;)

« previous php.notes (#66384) next »