"Unable to connect to db" error when trying to connect to my database.

[gdvconsu]

I receive the error "Unable to connect to db" when trying to connect from a web page on my site.

I'm not sure what the Host Name should be exactly:
I've tried localhost, x10hosting.com, xo4.x10host.com but, nothing seems to work.

I'm sure of the database name, user name and password just not sure of
Host Name: ????

Database Name: xyzconsu_contacts

User Name: xyzconsu_admin

Password: ********

Any help would be appreciated.
Thanks

 

[bdistler]

Any help would be appreciated

here is the full list of settings...

the following settings should be used:

Host/Server Name - [ localhost ]

Port - [ 3306 ] (not necessary)

Username --> Your cPanel username followed by an underscore and the MySQL username you configured in cPanel

Password --> The password that you used when creating the MySQL user

Database --> Your cPanel username followed by an underscore and the name of the database that you created in cPanel

NOTE: Free hosting accounts do not have remote MySQL access.

 

[gdvconsu]

Thank you for your timely response. I will have another go at using localhost as Host/Server Name though I'm pretty sure I tried that. Maybe the problem i elsewhere. I'll have to check it out more closely.

Thanks again for your help.