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

[Jonathan Schwartz]

Thanks, Dale.

This assumes that the query is actually hitting the remote server and failing.

The error message suggests that the query is being directed to the 
local server, not the remote server.

Still scratching my head.

Jonathan



>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 (<http://exit445.com>exit445.com), 
>>attempting to talk to the remote server.  You can see that php is 
>>actually trying to talk to the host 
>>"<http://exit445.com>exit445.com" instead. even though the the 
>>mysqlconnect command explicitly identifies the remote server as 
>>host (not <http://exit445.com>exit445.com) . No matter what I do, 
>>the mysqlconnect command attempts to talk 
>>to <http://exit445.com>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
>><mailto:jonathan at exit445.com>jonathan at exit445.com
>><http://www.exit445.com>http://www.exit445.com
>>415-370-5011
>>_______________________________________________
>>FX.php_List mailing list
>><mailto:FX.php_List at mail.iviking.org>FX.php_List at mail.iviking.org
>><http://www.iviking.org/mailman/listinfo/fx.php_list>http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>
>
>_______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list


-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-370-5011
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20100607/0d593390/attachment.html