database connection error

[dharshini]

Hai

i have two domains. i want to connect the database of one from the other domain. is it possible to do that.

i used the code
$host="www.hostname.com";
$posrt="3306";
$user="username";
$pwd="password";
mysql_connect("$host:$port",$user,$pwd);

but i got an error

Warning: mysql_connect(): Access denied for user: 'username@hostname' (Using password: YES) in /home/public/..

how can resolve the problem.

i created the access host through the cpanel, created username, added the user to that database.

is anything else to do.

thanks in advance.

[BigAlReturns]

If you're still about then yes this can be done. You need to find the IP address of the host you're trying to connect "from" (i.e. the one without the DB). You could do this via reverse ip sites, or cpanel may tell you somewhere. Then go to the cpanel of the site containing the database, go to the database options, and add this IP address to those allowed to access the DB.