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

[Dale Bengston]

Hi Jonathan,

There has to be a MySql user on the live site that will accept requests from your IP address or domain. Generally, this is pretty locked-down and you have to add the proper user account.

Hope this helps,
Dale



On Jun 7, 2010, at 11:20 AM, Jonathan Schwartz wrote:

> 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?
> 
> Thx
> 
> Jonathan
> -- 
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-370-5011
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100607/1bbc6178/attachment.html