Lost connection to MySQL server at 'reading initial communication packet'

[StealthParanoia]

I have created some PHP webpages for my friend using my localhost/ and gave them to him to upload his server.

After guessing the server that we had to connect to, we ran into some problems. Now, he is too shy to post on here and I'm bored of waiting for him to contact somebody so I'm doing it myself.

I have written the code as mysql_connect("liberty.xssl.net:2083", "usernamex", "passwordx") or die(mysql_error());
mysql_select_db("databasex") or die(mysql_error());

But this returns the error "Lost connection to MySQL server at 'reading initial communication packet', system error: 0".

Have I put the wrong host name in where it says "liberty.xssl.net:2083"? If so, what should I have put in?

Thanks,

~Finchyy

P.S. Where it says "usernamex", "passwordx" and "databasex" is where his actual username, password and database name is.

 

[Infopro]

Have I put the wrong host name in where it says "liberty.xssl.net:2083"? If so, what should I have put in?

Try replacing that with:
localhost

 

[StealthParanoia]

Try replacing that with:
localhost

Would that work on a server..? I know that that would work on your local machine but...

 

[Infopro]

Try it and see, let us know how it goes.

 

[quietFinn]

Would that work on a server..? I know that that would work on your local machine but...

If the PHP application and mySQL are running in the same server then you can use "localhost".

 

[Jben Kaye]

Try replacing that with:
localhost

hi I have the same problem i tried replacing the hostname to localhost but it gave me this error Access denied for user '[email protected]'@'localhost' (using password: YES). How can i solve this one? thanks

 

[cPanelMichael]

hi I have the same problem i tried replacing the hostname to localhost but it gave me this error Access denied for user '[email protected]'@'localhost' (using password: YES). How can i solve this one? thanks

It looks like you may not be using a valid format for your MySQL username. Check to make sure you enter the database username exactly as it appears in cPanel.

Thank you.