Problem connecting to the database server

[overtmc2]

I am trying to set up osCommerce...got this error right the bat:

 

~~~~~~~~~~~~~~~~~~~~~

 

There was a problem connecting to the database server. The following error had occured:

 

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

 

Please verify the connection parameters and try again.

 

~~~~~~~~~~~~~~~~~~~~~

 

Any help is appreciated.

[usernamenone]

Having set up your database first and then the install, you will need to use the correct user name, password and server of the database. These setting can be found in the control panel where you set up your database.

[Guest]

I am trying to set up osCommerce...got this error right the bat:

 

~~~~~~~~~~~~~~~~~~~~~

 

There was a problem connecting to the database server. The following error had occured:

 

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

 

Please verify the connection parameters and try again.

 

~~~~~~~~~~~~~~~~~~~~~

 

Any help is appreciated.

Try creating your database before installing osc. Keep a note of the database name, user name and password because you will need it during the osc installation process.

[overtmc2]

I do have a MySQL database set up. It is a brand new database, with no tables. I can connect to the db in phpMyAdmin, no problem. I did go in and create a test table, without any issues. When I use the same credentials on the OSC setup, I still get the error in my original post.

 

Could it be a permissions issue? I am using a third party hosting company (Alentus). It is a windows environment, but runs php. Could it be that they are using some old software?

[overtmc2]

Fixed the first error, now I am getting:

 

Unable to connect to database server!PHP Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in D:\Websites\www.mysite.com\catalog\admin\includes\functions\database.php on line 19