Hey guys. I have a Main site on 1 server and the Admin and MySQL DB on another server. These are not on a local network, they are in 2 totaly different locations.
For some reason I can not get the main site to connect to the remote database. I have tried using the IP address of the remote DB, but it says access denied. How do I format the string to allow me to connect remotely to this database?
Here is an example of what I am using.
$Hostname = "11.11.11.111:2222";
$Database = "db_name";
$Username = "user_name";
$Password = "thepassword";
$Connect = mysql_connect($Hostname, $Username, $Password) or die("<div align=center>Sorry, we are currently experiencing technical difficulties, please try again later.</div>");
mysql_select_db($Database, $Connect) or die( "<div align=center>Sorry, we are currently experiencing technical difficulties, please try again later.</div>");
Thanks!😃
