Unable to remotely log into MySQL

[Aludaan]

Hello,

I am running MySQL v5 and I am having the following problem connecting remotely into a MySQL database:

Warning: Access denied for user: 'bill@Linux' (Using password: YES) in /home/www/html/bill/test.php on line 6
Warning: MySQL Connection Failed: Access denied for user: 'bill@Linux' (Using password: YES) in /home/www/html/bill/test.php on line 6

I can run a very basic script which will work on the localhost but not when I use the ip. Even if I run the script on the localhost with the local hosts IP or name it will not work. Below is a copy of the script:

$dbuser= "user"; 
$dbpw="password"; 
$db="dbname"; 
$mysql_access = mysql_connect("ipofremoteserver", $dbuser, $dbpw); 
mysql_select_db($db, $mysql_access); 

$ipquery = "SELECT field1, field2, field3 FROM database"; 
$ipresult = mysql_query($ipquery, $mysql_access) or die(mysql_error()); 
if(mysql_num_rows($ipresult)) 
{ 
while ($iprow = mysql_fetch_row($ipresult)) 
{ 
$ipbase = $iprow[0]; 
$ipsubnet = $iprow[1]; 
} 
} 

I have 3 accounts set up, one that allows me access from every host, one from localhost and one even from the specific host I am trying to connect from but I still get that error.

Any thoughts are greatly appreciated,

Bill

[Aludaan]

Thanks but I found out the reason already. As it turns out it was my password to the database. I was using upper and lowercase letter as well as numbers to end the password. Apparantly that will work when you directly log into the server but for some reason when I would try to log in from another server using a script it would not. I changed my password to just lowercase letters and everything is working again.