Connecting to MySQL on a different server

gmchun83

New Member
I have two servers (virtual machines - I can remotely connect to these) - server 1, and server 2.On server 1 I keep my webpages, and on server 2, I keep the databases.I am currently trying to connect to a database on server 2 from server 1. Here is my php code:\[code\]<?php $dbhost = 'xxx.xx.xx.xx:xxxx'; $dbuser = 'xxxxxx'; $dbpass = 'xxxxxx'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql' . mysql_error()); $dbname = 'database'; mysql_select_db($dbname);?>\[/code\]This is the error message I get when I try to connect:\[code\]Access denied for user 'xxxxxx'@'server1' (using password: YES)\[/code\]I found it a bit puzzling that it says @server1 considering I'm trying to connect to server 2. Can anyone offer any insights?Thanks PS: They're both on windows 2008
 
Back
Top