I was just reading about this on the MySQL web site.
It seems they have change the authentication protocol
starting with version 4.1
There is a note that clients like PHP, Perl etc will
need to be recompiled to support the NEW protocol. For
now I'm sticking with MySQL 4.0.1
Paul
--- "Michael G.
Code below comes straight out of the manual. I can connect using mysql client on other
pc, and using SQLyog. but Php will not connect. I can run php scripts with no problem
otherwise.
Setup is: Win2k - sp3; php 4.3.2 ; Mysql 4.1; Apache 2.
This is the error I get:
;
Warning: mysql_connect():
