Failed to connect to the MySQL database - Please check your settings

[Angela Horn]

Can someone tell me how to enter my database info? In the manual it says the following:

MySQL hostname: localhost
MySQL database: (database name)_database
MySQL username: (username)_username
MySQL password: (password)

But when I do this it says it failed to connect.

[Brian Collins]

Hi Angela,

Did you create a database as instructed?

If so, the details of your database will be in the mySQL section including the database name - accountname_databasename etc. and you should use the password you set the database up with (not forgetting to grant ALL access to your database user for that database).

It is rare these days but it is worth checking with your host that using localhost is the correct thing to do - some hosting suppliers give alternative instructions for the correct entry here.

Brian

[Andre Foisy]

Can someone tell me how to enter my database info? In the manual it says the following:

MySQL hostname: localhost
MySQL database: (database name)_database
MySQL username: (username)_username
MySQL password: (password)

But when I do this it says it failed to connect.


Hi Angela,

1st did you create your database?
The above a re just example of what you might see as the naming structure. What you should paste in these fields is the exact name you have when you create your database.

When starting creating databases people often just forget to keep note of this information. If so, don't panic ;D just redo the process and create new database except this time take note of, like select copy and paste in a notepad, each naming you see in your cpanel.

Very likely the naming will appear as yourserverloginname_nameyougive
For example: If you name your database delavo and your login name on cpanel is angie then your database name will be angie_delavo - this is the database name and the same will apply for the database USERname except for the password which you'll need to copy and paste exactly as you name it.

localhost will very likely be the hostname in 90% of the cases, though you can check with your hosting support to make sure.

I hope you see the light :)

Andre Foisy