Client does not support authentication protocol requested by server

[ichini]

I don't know if this is the place to put it but I'm looking to find some answers. I run an Oscommerce e-store hosted at Hostroute.com. PHP 4.4.6, Mysql 4.1.22-standard

 

I woke up this morning to find my website down with the front page showing this error:

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/gessho/public_html/includes/functions/database.php on line 19

Unable to connect to database server!

 

 

I've made no recent changes to the code so my assumption is my host has made some kind of change/upgrade to the mysql server. I'm still awaiting an answer from my host's tech support.

 

In the meantime I'm wondering if there is a way I can fix this easily. This seems to keep popping up everywhere I search:

 

UPDATE user SET password = old_password('password') WHERE user = 'user';

FLUSH PRIVILEGES;

 

Can I enter this in mysql phpMyAdmin, or do I need to be running my own Mysql on my own server? Do I need to ask my host to fix this if my mysql databases are being hosted on their server? I've tried creating a new user/password on Cpanel and using that user, but there is no difference and I"m lost right now as to what I can do.

[fenway]

As long as you have root access, you can update the users table.