Page 1 of 1

Error Connecting to database

Posted: Sun Jun 11, 2006 12:34 am
by 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?

Posted: Sun Jun 11, 2006 10:51 am
by 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'