Please proof your database settings! error msg

Jannette · Post by **Jannette** » Mon 9. Jul 2007, 06:23

Trying to install PHPWCMS, Step 3 (can't get too far!!!) "3. MySQL database settings" I'm getting the message "Please proof your database settings!" HAH? What does this mean? and How do I fix it?

Please help.

Post by **flip-flop** » Mon 9. Jul 2007, 08:36

Hi Jannette,

have you set all right for files and folders http://www.phpwcms-docu.de/installation_en.phtml
After this you have made please call setup/setup.php.

All database settings right?

Knut

Jannette · Post by **Jannette** » Mon 9. Jul 2007, 09:53

Dear FlipFlop,

Thank you for replying.

Yes, following the instructions very carefully. All the files/folder settings have been done as per instructions.

Database permissions? I created a database and called it "friend". (not the quotes!!). I must be doing something awfully dumb, no-one else seems to have had this problem! I don't know how to do anything else like permissions to the database. Very Very new at this. Sorry for my ignorance.

Post by **flip-flop** » Mon 9. Jul 2007, 10:30

MySQL host: normaly: localhost but some providers have an own db adress.
DB user: The user name is generated by the provider
DB password: The password is generated by the provider or it is changed by yourself.
DB database: That is the name you have given your db during creation. In your case: friend.
DB table prefix: Normaly leave it blank.

All this informations you will find in the backend of your provider account.

Knut

Jannette · Post by **Jannette** » Tue 10. Jul 2007, 02:00

Dear Flip-Flop,

I've double checked everything you pointed out. Something is amiss!!!
Checked host = localhost
checked DB user
checked DB password
checked DB database

AAArrghhh what is it???

wireless · Post by **wireless** » Tue 10. Jul 2007, 04:42

If I may.

sometime it is like this:

DB user = domain login username with database username

example: domain_username

same goes for DB_database

example: domain_databasename

that is how mine works

Jannette · Post by **Jannette** » Tue 10. Jul 2007, 05:54

Dear all,

I have no idea, I've deleted and recreated the database, (same name, different name, short name, long name etc etc), recreated the user and password.

All to no avail.

Whatever I'm doing, I'm obviously repeating the error.

Wireless, thank you for your input. I tried it with and without the domain_user etc. When I created the database, the user name comes up as domain_username, domain_databasename etc so I put that in and tried it too - no good!

Anyone got any other ideas?
I'd greatly appreciate any efforts in helping me.

Post by **flip-flop** » Tue 10. Jul 2007, 06:56

Please have a call to your provider or a look into his faq / forum.
Is there a provider discription to use a db?

I think that is a deeper problem.
What is the name of the provider?

Knut

pico · Post by **pico** » Tue 10. Jul 2007, 08:23

Hi - all Good People,

some Hints

- first check that Database-Host is correct, not everytime it works with 'localhost' - look in your Account-Info and you will find a Hostname or sometimes a IP-Addres for connecting to the Database - if you manage the Database with phpMyAdmin you mostly see here also the Hostname.
at my Provider it looks like 'db123.domain.tld'

- when you create a User for the Database also be shure that this User gets Permissions to create, update and delete Tables. This User must also assigned to the Database you create. If you create a Database with the 'Root' Account, the created User will not automaticly gets the Permissions to your Database!
If you can't create Users - mostly on Hosting-Packs - you must use the Username and Password what your Provider has given to you.

- you wrote that you can create a Database - are you shure or did you mean that you create a Table ? On most Hostings you can't create Databases, you will get the Databasename also from your Provider
in my case it looks like 'db12345678'

maybe this will help you

Jannette · Post by **Jannette** » Tue 17. Jul 2007, 05:54

I contacted the host people and it mysteriously worked! I don't know what they did but it is now working.