Terry Lalonde wrote:
Sarcastic tone on -> Thanks for the help!
Congratulations on solving your problem on your own; less than 10 hours elapsed between your first post and your follow-up.
Since I figured it out...I'll share.
In this case the problem was the fact that I was using PHP4.x.x and mysql4.1.10. There is a basic incompatability between the two in terms of password authentication.
If you were to search the mailing list archives for "MySQL 4.1" you'd see a number of previous notes on this with pointers to the help pages on dev.mysql.com. This is also mentioned in the release notes for all 1.4 beta releases.
Note that there is not actually a basic incompatibility between PHP 4.x and MySQL 4.1; PHP 4.x will work fine with MySQL 4.1 if you link it against the MySQL 4.1 client libraries. Most precompiled binary distributions however are linked against older, incompatible libraries. If you received both PHP and MySQL distributions from the same vendor, you should let them know they're shipping incompatible versions.
If you're using MySQL 4.1, you should also be aware that mysqldump may corrupt your data if it performs character set conversion. Use the same charset setting for dumping as the database is set to (eg, latin1 for both).
-- brion vibber (brion @ pobox.com)