jhelton- Typically your host would create the database and furnish you with it’s name and user/password combination. Did they give you the information in that you refer to in your post? If yes, I can’t imagine what would be wrong. If you simply created the name/password information from scratch, that won’t work; the information must correspond to what the host has designated for the database.
DB~
The answer will vary depending on the host, however, the DB user and pw, usually, are NOT the same as the site user/pw!
Sorry for the confusion. Started an SQU database with the provider. DB name “FRC”; authorized admin user name, “jhamilton”; then the password used by jhamilton to access the database, xxxxxxxx (I didn’t want to put the real password). Anyhow, placed that info into the config file and still get the error unable to connect to the database. I saw some postings about something called a fully qualified db name and fully qualified username need to be in the config file. is there a difference between a fully qualified DB name and what I called it, FRC, etc.
Thanks
1. I hope it’s just a typo: SQU. It should be MySQL. WP doesn’t work with any other type of database!
2. The username’s format has a wide range of variation depending on hosts. I don’t know what a “fully qualified DB name” is.
3. Case sensitivity? FRC is not the same as frc.
4. Which error message you got? There are 2.
I’ve seen Network Solutions using an IP address such as for the DB_HOST.
What do you have for your DB_HOST?
Sometimes your database info will need to be prepended by your “username” (which is what you would have been given by the host when you first signed up) – so your database info will look like this:
define('DB_NAME', 'username_FRC');
define('DB_USER', 'username_jhamilton');
define('DB_PASSWORD', 'password');
define('DB_HOST', 'localhost');
Sorry, I should have resolved this thread. Network Solutions requres the ip address in the DB_Host file. I found the ip address for the SQL server in the Manage section of the SQL setup and placed that into the DB_Host name. Worked like a champ after that.
Thanks to everybody that posted.
