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.
For example,
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.
Thanks
----- Original Message -----
From: "Fernando Gomes Bernardino" <[EMAIL PROTECTED]>
To: "MySQL - Lista Internacional" <[EMAIL PROTECTED]>
Sent: Wednesday, December 03, 2003 12:33
Subject: Re: Client does not support authentication protocol requested by
server
>
> > Warning: mysql_pconnect(): Client does not support authentication
> protocol
> > requested by server. Consider upgrading MySQL client
>
> #1249 - Client does not support authentication protocol requested by
> server.
> 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/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
