Problem connecting to MySQL w/ phpMyAdmin and Web via php

[djbeta]

I'm running the 4.1.10a MySQL server (standard installer) on Mac OS 10.3.8

My installation of MySQL seems fine.
I've been using the Terminal Window to create and work with databases.

When I try to connect with phpMyAdmin, I get this error:

MySQL said:

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Then..

I tried writing a simple php page that connects to one of the MySQL databases, and I get the same error.

Any ideas what this is and how I can fix it ?

One thing that might have caused this is (i'm guessing but may be very wrong) is that using phpmyadmin I changed the root password for localhost from nothing to something that I use.

(but I use that password in the phpmyadmin file and the php connect script so it should be fine I thought)

thanks

 

[azzazzello]

read this and follow the instructions

http://dev.mysql.com/doc/mysql/en/old-client.html

 

[annonhong]

I have MySQL 4.1.11 NT version and the my.ini had the wrong variable name for the old passwords.

it had: old-passwords
but should be: old_passwords

It took me a while to notice that there is a difference.