You will need to start MySQL with --OLD-PASSWORDS option.
Or simply put OLD-PASSWORD in [mysqld] section of your options file.
Or when creating your passwords, make sure you update the password column
using OLD_PASSWORD() function.
UPDATE mysql.user SET password=OLD_PASSWORD("your_password") WHERE
Host="your_host" AND User="your_username"
You also asked what might be wrong: that is due to that your PHP doesn't
support the new passwords used by MySQL 4.1
Also, using empty passwords does the trick.
Hope this helps.
----- Original Message -----
From: "Fernando Gomes Bernardino" <listasmysql@stripped>
To: "MySQL - Lista Internacional" <mysql@stripped>
Sent: Wednesday, December 03, 2003 12:33
Subject: Re: Client does not support authentication protocol requested by
> > Warning: mysql_pconnect(): Client does not support authentication
> > requested by server. Consider upgrading MySQL client
> #1249 - Client does not support authentication protocol requested by
> Consider upgrading MySQL client ??????????
> I have MySQL 4.1 on Linux. The "mysql_fix _privilege_tables" is the
> problem, I think. What can I do??
> Fernando Gomes Bernardino
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1