Re: how do I get a remote db connection?

* Thus wrote Irvin Amoraal (irvin@cabletv.on.ca): > 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: 'abc@my_web_host.net' 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."