Remote Sql Access

[SSEi95]

Not sure if this is more a hosting thing, or a phpbb thing, but here goes...

 

I have site xxx.com here, and xxx.net elsewhere. What I want to do is to have the phpbb file on xxx.net point to a backup db I have here on my xxx.com account. (follow so far?) Here is what I have tried so far....

 

$dbhost = 'xxx.com'; (with and without the www)

$dbport = '3306'; (with 3306 and with nothing)

$dbname = 'cpanelname_dbname';

$dbuser = 'cpanelname_dbusername';

$dbpasswd = 'dbpassword';

 

 

and here is what I get back on my site...

 

General Error

SQL ERROR [ mysql4 ]

 

Access denied for user 'cpanelname_dbusername'@'' (using password: YES) [1045]

 

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

 

Do I have the remote sql information wrong here? Or is there something going on with the other site that tries to link back here? I have added the xxx.net site to the list of approved remtoe SQL sites already in both the xxx.net and www.xxx.net formats. any help would be appreciated.

[SSEi95]

Intersting... I found out that in the remote database access hosts settings I can get it to work by adding %.net. If I go any closer to the actual domain name though, or should I say put anything in front of the ".net" other than the % the connection will fail.

[Bob Crabb]

with the Remote SQL set to %.net, you have authorized access for any .net domain name.

 

Looking at the error, access is denied for cpanelname_dbusername'@'; I think that it will work if you allow access to and xxx.net.

 

I ran into the same thing when I wrote an application where a script on one site accesses the database on another. I got it to work by allowing remote access to the domain name of the remote site and to the remote server.

[SSEi95]

hahaha... that was so simple, and right in fornt of me too. That was it. Working great now. Thanx!