03-01-2017, 01:06 PM
Would you mind telling me the name of your hosting provider?
It is almost always bad credentials that cause this error. Have you setup a database on this server before?
Sometimes the hostname is not localhost/127.0.0.1. On Dreamhost, it's something like mysql.mydomain.com. Absolutely knowing your host name is important.
Step 2 is your database name. Some systems use your username as a prefix, so even though you create a db called us your system could call that cjm_us
Step 3 your username may be the same thing.
Step 4. You have to know your password.
Finally, not all systems automatically create a database user when they create a new database. It is also possible to have a database and a user and not have them connection. I know this sounds really complicated.
Personally, I would try to create a new database (ideally with some sort of wizard) to make sure that you absolutely know all the associated information.
It is almost always bad credentials that cause this error. Have you setup a database on this server before?
Sometimes the hostname is not localhost/127.0.0.1. On Dreamhost, it's something like mysql.mydomain.com. Absolutely knowing your host name is important.
Step 2 is your database name. Some systems use your username as a prefix, so even though you create a db called us your system could call that cjm_us
Step 3 your username may be the same thing.
Step 4. You have to know your password.
Finally, not all systems automatically create a database user when they create a new database. It is also possible to have a database and a user and not have them connection. I know this sounds really complicated.
Personally, I would try to create a new database (ideally with some sort of wizard) to make sure that you absolutely know all the associated information.