MySQL on Intranet Question

[Greg]

I have installed MySQL 4.1.7 and PHP 4.3.9 on our server. I'm trying
to setup a form on our intranet website to submit orders from other
stores (on the intranet) to a MySQL database. I've got the form trying
to submit but get the following error message: "Warning:
mysql_connect():Client does not support authentication protocol
requested by server; consider upgrading MySQL client in
C:\infosite\add.php on line 7 Unable to connect to database" I've
read about a password authentication change in 4.1 and have tried
setting the variable "old-passwords" to "On", tried putting
"old_passwords" in the my.ini file. Neither made any difference. I can
log into MySQL and create databases and tables via the command line.
I've VERY new to MySQL and would appreciate any help that I can get.
Again, I'm very new at this so please be as explicit as possible with
your explinations.

Thanks,

Greg

[The Collective]

Greg wrote:

I have installed MySQL 4.1.7 and PHP 4.3.9 on our server. I'm trying
to setup a form on our intranet website to submit orders from other
stores (on the intranet) to a MySQL database. I've got the form trying
to submit but get the following error message: "Warning:
mysql_connect():Client does not support authentication protocol
requested by server; consider upgrading MySQL client in
C:\infosite\add.php on line 7 Unable to connect to database" I've
read about a password authentication change in 4.1 and have tried
setting the variable "old-passwords" to "On", tried putting
"old_passwords" in the my.ini file. Neither made any difference. I can
log into MySQL and create databases and tables via the command line.
I've VERY new to MySQL and would appreciate any help that I can get.
Again, I'm very new at this so please be as explicit as possible with
your explinations.

Thanks,

Greg

Hey Greg,
Have you tried using OLD_PASSWORD function when setting up your user?