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

[Joel Shapiro]

Hi Jonathan

 From the "Warning" you posted, it looks to me like the username  
that's being denied is:  '[USER]'@'exit445.com'

Per Dale's comment, is '[USER]'@'exit445.com' a valid username?

-Joel


On Jun 7, 2010, at 1:52 PM, Jonathan Schwartz wrote:

> 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 (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
>>
>>
>> _______________________________________________
>> 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
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list