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.
Could it be that remote acccess to the db is disabled? Or am I omitting something?
Yes, more than likely. You need permission within the grant tables for Site A to connect to it from host Site B.
-- ---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
PHP|Architect: A magazine for PHP Professionals – www.phparch.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
