I have the privileges set for my databases. I have tried to connect to the MySQL server (version 4.1.7) using PHP version 4.3.9. My OS is Windows XP.
I have received this message -
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
I understand that this is because PHP 4.3.9 doesn't support the new 41 char password encryption and I need to run the mysql_fix_privilege_table. Is the script below correct for the Windows platform ?
mysql> --force mysql < mysql_fix_privilege_tables.sql
Is there any other advice you can give me that pertains to this error ?