problems with php & mysql

[Anon]

hello the error that i get when i try to use this script to test a db i get several errors and dont know what they mean or if there is a problem with the php script, i tried to look for stuff in the apache conf file too see if any changes had to be there but could find none, i get the test information about the system fine with php, but just db problems.
The errors i get are:
Warning: MySQL Connection Failed: Host '' is not allowed to connect to this MySQL server in /apache/htdocs/one.php
on line 7
Warning: Supplied argument is not a valid MySQL-Link resource in /apache/htdocs/one.php on line 8
Warning: Supplied argument is not a valid MySQL result resource in /apache/htdocs/one.php on line 9

<?
$dbuser = 'root';
$dbhost = 'localhost';
$dbpass = 'password';
$dbname = 'test2';
$dbtble = 'books';
$mysql_link = mysql_connect($dbhost,$dbuser,$dbpass);
$column = mysql_list_fields($dbname,$dbtble,$mysql_link);
for($i=0; $i< mysql_num_fields($column); $i++ )
{
print mysql_field_name($column,$i )."<br>";
}
?>

anyhelp would be appreciated, ive been rackin my brain over this for over a week.
I changed the localhost to the server ip password to roots password and nothing

[billford]

hmmm, works fine on my server, Have you correctly setup MySql? Can you connect with mysql -u root -p <dbname>? Have you run the necessary install_db shell script?

[jariizumi]

Looks like MySQL tries to resolve your 'localhost' to ''. You should check your ifconfig's and see exactly what interfaces you have set for 'localhost', and then check your /etc/hosts file and see if that's referring to the right one.

What might be good is to connect without any params, see what the "default" server is, since it might be better than blank. If it won't connect, you at least can check your error logs and see what in the world the problem is.

And remember to give that user access for that hostname.