Please proof database settings!

[mshaker]

I get this message even thought hte below have been double checked countless time:

MySQL host: localhost
DB user: exists in mysql
DB password: is correct
DB database: exists in mysql
DB table prefix: blank

using mysql 5.0

[juergen]

MySQL host: localhost

Shure ?

[mshaker]

Yes I'm sure about the localhost.

[juergen]

Hmm

Is there a phpmyadmin running on your system ?

[mshaker]

I have been using the mysql 5.0 gui tools. It's odd as the interface for the gui tools ask the same questions as the phpWCMS setup tool. The gui tools however sign me into my cms database. I can even run the phpWCMS default_sql scripts inside the gui tool with no problem. Will it help to install phpmyadmin?

Thanks for the help!

[juergen]

no, no help from this.. I asked to see any info about the name of the sql server. ask your hoster....

[mshaker]

Thanks for your help! Found problem to be with using MySQL 5.0. After creating a quick script to connect, I found I was getting the below:

Client does not support authentication protocol.

This led me to a fix in MySql to perform the following command:

MySQL 5.0 uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older (pre-4.1) clients. If you upgrade the server from 4.0, attempts to connect to it with an older client may fail with the following message:

shell> mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client

To solve this problem, you should use one of the following approaches:

* Upgrade all client programs to use a 4.1.1 or newer client library.
* When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password.
* Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

After doing this...the install worked great!!!!