Error when trying to connect to database

[mattm591]

Hi,

I've set up a test server on an Ubuntu system.

I installed and configured Apache, PHP and MySQL however, whenever I try to connect to a MySQL database I get this error:

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/index.php on line 8
Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Does anyone know what is causing this and how I can solve the problem?

Thanks,

Matt

[bpat1434]

MySQL AB :: MySQL Forums :: PHP :: 'reading initial communication ...

Seems like using the loopback IP doesn't work. How are you connecting? Try using localhost as the host first, and see what happens.

[mattm591]

Nope, tried localhost and I still get the same error.

[bpat1434]

Hmm.... I'm not sure. I've never run into this. Have you searched the MySQL forums?

[mattm591]

Thanks for the help. I have no idea what was wrong but reinstalling everything has fixed it all!