Error Connecting to database

[chuckking]

Script URL: http://www.canalfultonpc.com/ticket
Version of script: Version: 0.93 from July 5, 2005 (patch 0.93.1)
Version of PHP: 3.01
Hosting company: Self
Have you searched THIS FORUM for your problem: Yes
(if not please do before posting)
If so, what terms did you try: Searched Helpdesk Forum

Write your message below:


I receive this error when attempting to connect to the database.

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in e:\domains\canalfultonpc.com\wwwroot\ticket\install.php on line 160



Cannot connect to database, please check your database settings.

I have the correct database settings entered in the setup script.
any ideas?

[Klemen]

Hi,

This is a problem with MySQL, you (or your host) probably upgraded MySQL recently? You should ask your host (or do it yourself if you have root access) to make sure MySQL has compatible old passwords, like this:

UPDATE mysql.user SET Password = OLD_PASSWORD('password') WHERE User = 'user'