MSQL error on install

[bestsitestuff]

I uploaded the Catalog database to server then using my browser try and install.

A test connection made to the database was NOT successful.I keep getting the following error ..groan Tried adding another version 5 Mysql database cos i saw some errors on 4.01 but still no joy <_<

 

The error message returned is:

 

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

 

Please click on the Back button below to review your database server settings.

 

If you require help with your database server settings, please consult your hosting company.

 

Any ideas..help much appreciated .. Thanks Colin

[kgt]

This is a common problem:

 

http://www.google.com/search?hl=en&q=C...G=Google+Search

[bestsitestuff]

This is a common problem:

 

http://www.google.com/search?hl=en&q=C...G=Google+Search

 

 

Thanks changed the coding as in google --- SET Password = OLD_PASSWORD('newpwd')

 

Now I connect but get an error that " SQL file does not exist: /install/oscommerce.sql" hmmm maybe need to upload Catalog again. Will check on server first though .

[kgt]

Thanks changed the coding as in google --- SET Password = OLD_PASSWORD('newpwd')

 

Now I connect but get an error that " SQL file does not exist: /install/oscommerce.sql" hmmm maybe need to upload Catalog again. Will check on server first though .

 

 

Another common problem. This one due to windows and IIS. See:

 

http://www.oscommerce.com/forums/index.php?showtopic=187283

http://www.oscommerce.com/forums/index.php?showtopic=162231

[bestsitestuff]

Thanks changed the coding as in google --- SET Password = OLD_PASSWORD('newpwd')

 

Now I connect but get an error that " SQL file does not exist: /install/oscommerce.sql" hmmm maybe need to upload Catalog again. Will check on server first though .

 

 

well i see the oscommerce.sql file hmmm .

[bestsitestuff]

not exactly simple stuff is it ..lol .. i am game but this is getting beyond my level of understanding . thks