MySQL Database

[steve36]

cannot connectLost connection to MySQL server at 'reading initial communication packet', system error: 110
sunndely i get this very strange error.... previous my appliaction hosted on the server worled absolutely fine, without any problems. I can not connec to my dadabase, but the password and the URL to the database is correct.

please help

cheers
steve

 

[Skizzerz]

1) make sure you are trying to connect to "localhost", not anything else
2) verify that the username has been added to the appropriate database in the MySQL Databases page in cPanel.

Please note that you cannot access MySQL from outside of your website (aka "Remote MySQL") as this is disabled on free hosting.

 

[steve36]

well I tell you again:

it worked fine since weeks, and suddenly without changing anything, it gives me this error
Lost connection to MySQL server at 'reading initial communication packet', system error: 110.

 

[stpvoice]

Hello,

You've conveniently left your config.ini visible via directory listing.

[database]
host   = stoli.x10hosting.com
user   = [removed]
pass   = [removed]
dbname = [removed]
dbtable = [removed]

The host should be "localhost" without the quotes.

Thanks.

 

[steve36]

and why does this work and not the full servername?! iam just interested, because previously it worked with the full servername....

 

[stpvoice]

Hello,

Not sure why it worked before. Usually "localhost" is the only thing that will work.

Thanks.

 

[steve36]

yeah thanks.... i also have no idea why it worked, and now not anymore.... when you find it out somehow somewhen, please let me know.

 

[stpvoice]

It probably won't work again. Chances are things are still being tweaked after recent updates. Localhost has always been the only thing that will.