* Thus wrote Irvin Amoraal ([EMAIL PROTECTED]):
> I have two independent websites, both with their own mySQL db's. I would
> like to run a query in site A against site B's database. I am trying to
> establish a connection using something like:
> $conn = mysql_connect("abc.com:3306", $user, $pass);
>
> A warning is returned to the browser :
> Access denied for user: '[EMAIL PROTECTED]' where my_web_host.net is the
> name of the host server.
>
> The db's name would be abc_com (This is not the actual name but the form is
> consistent with the real db name).
>
> If I try port 3307 I get "Can't connect to MySQL server on 'abc.com'(111),
> so I assume that I am able to communicate with the msSQL server itself, but
> is a permissions issue. I know that the username and password are correct.
Correct.
>
> Could it be that remote acccess to the db is disabled? Or am I omitting
> something?
Yes, the remote host doesn't allow connection from the host you are
conecting to. You'll need to add permissions on B's database for
host A.
HTH,
Curt
--
"I used to think I was indecisive, but now I'm not so sure."
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
