[FX.php List] Trouble connecting to remote mySQL DB

Jonathan Schwartz jschwartz at exit445.com
Mon Jun 7 10:20:57 MDT 2010

Sorry for the off topic post.

Some background...This is my one foray into mysql, where I'm using a 
mysql db on a client's primary website as a way to control web 
traffic to two other servers, where FileMaker Web Publihsing is 
running.  In short, the mysql db has just 10 records, providing 
location and status of the various processes offered on the FieMaker 
servers.  We use it to put up "We'll be right back" signs when 
maintenance is being performed, among other things.

I previously did this in FileMaker, but if Fileaker is down, it can 
not report on itself.

To the problem.  While I can perform mysql_connect from a php page on 
the www site, I can not connect up  to mysql from a php page located 
on the remote server.  I get the following error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for 
user '[USER]'@'exit445.com' (using password: YES) in 
/Library/WebServer/Documents/..........opendb.php on line 4
Error connecting to mysql

This is being run from my server (exit445.com), attempting to talk to 
the remote server.  You can see that php is actually trying to talk 
to the host "exit445.com" instead. even though the the mysqlconnect 
command explicitly identifies the remote server as host (not 
exit445.com) . No matter what I do, the mysqlconnect command attempts 
to talk to exit445.com.

I did check with the www host and there is no restriction from 
accepting remote quieries.

Assuming I understand what is happening, how do I convince php/OS X 
Server to talk with the remote server instead of the localhost?


Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100607/9169fc0b/attachment.html

More information about the FX.php_List mailing list