Host not allowed to connect to MySQL server (#1103)

[mattm591]

Hi,

I have just installed Xampp for LInux on Ubuntu 7.10 and tried to connect to the MySQL server using a simple script.

However I cannot connect. mysql_error() returns the following:

Code: Select all

Host 'Y2K-Laptop' is not allowed to connect to this MySQL server

and when I try to connect to it from another computer using Dreamweaver I receive error #1103.

What is wrong and how can I solve this?

Thanks,

Matt

[Wiedmann]

However I cannot connect. mysql_error() returns the following:

You have used:
$db = mysql_connect('localhost', 'foo', 'bar');
?

[mattm591]

No. I am trying to connect to the server from a computer which isn't local so it's;
$db = mysql_connect('y2k-laptop', 'foo', 'bar');
sorry I should have made this clear.

Edit: Sorry, I just realised I hadn't changed the user to allow connections from any host.. problem solved!