I haven't used mysqli, so I'm not as familiar with errors related to
that library, but you said you downloaded "the latest package of MySQL,"
which is hopefully 4.1.12. This version shouldn't cause this error with
mysqli. In my experience, this error has always been a case of PHP
compiled against MySQL 3.x libraries, so that the PHP client is using
the older authentication protocol of 3.23. See below for more information:
http://dev.mysql.com/doc/mysql/en/old-client.html
kgt
Richard Lynch wrote:
On Fri, May 13, 2005 3:56 pm, Sam Smith said:
Because the install was from mysql.com I don't want to believe the client
is
out of date. I also don't know how to install another client.
Most likely, it's Apple that's a bit behind the curve...
So your phpMyAdmin is probably trying to use the mysqli client, but your
MySQL server from Apple can only handle mysql client.
See if you can get phpMyAdmin for the version of MySQL you have.