CONNECTION SETTING IN ANOTHER SERVER

taurus5_6

I want to establish connection in one of my website1 database, how can I establish connection to that database coming from my website2 hosted in different server.

The following is my default connection settings in my website1, Im thinking of changing the localhost to something like www.website2.com but the following error is shown

Access denied for user 'myusername'@'64.92.148.156' (using password: YES)

<?
$dbservername = "localhost";
$dbusername = "myusername";
$dbpassword = "mypassword";
$defaultdb = "mydatabase";
$cn = mysql_connect($dbservername,$dbusername,$dbpassword) or die("connection error ".mysql_error());
$db = mysql_select_db($defaultdb);
?>

cahva

You have to add a new database user to website2.

User: myusername
Server: 64.92.148.156 (website1 server)
Password: *************

(you can duplicate the existing user and change the server from where are you connecting)
Usually users are added with server 'localhost' only so that it cannot connect from anywhere else than the server it is on.

It can also be possible that adding new user wont work if the server(website2) has disallowed outside connections and only listens to localhost.

taurus5_6

cahva wrote:
You have to add a new database user to website2.

User: myusername
Server: 64.92.148.156 (website1 server)
Password: *************

(you can duplicate the existing user and change the server from where are you connecting)
Usually users are added with server 'localhost' only so that it cannot connect from anywhere else than the server it is on.

It can also be possible that adding new user wont work if the server(website2) has disallowed outside connections and only listens to localhost.

Thanks. I just want to make my point clear though,

WEBSITE1 is where my database are stored
WEBSITE2 is the external website which I want to grant access to my website1 database.

Is your instruction above suit to this description or should I interchange them?

taurus5_6

The former error was gone but when I make a search query in my "search page", the following error is shown:

Warning: mysql_query() [function.mysql-query]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/website1/public_html/myfolder/result_new.php on line 171

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/website1/public_html/myfolder/result_new.php on line 171
Query Error1 Access denied for user 'nobody'@'localhost' (using password: NO)

I tried some troubleshooting and I found out that the error appears when my <? include ... ?> functions uses absolute URL such as <? include("http://www.website1.com/myfolder/myfile.php"); ?>

I can not do a relative url though because I am at website2 and putting <? include("myfile.php"); ?> would mean <? include("http://www.website2.com/myfile.php"); ?> right?