Thanks for your help. I beleive it was the point. I tried php 5.0.4 with mysql 4.1.13a on Windows XP running apache 2.0.54. Knowing the fact that mysql support is not enabled by default, and must be manually set in php.ini, it works fine with this new auth. hashing. On 8/17/05, Jon <jonraston@xxxxxxxxxxx> wrote: > You need to check the MySQL manual about the password hashing > http://dev.mysql.com/doc/mysql/en/password-hashing.html and change to the > old version of passwords as a workaround. I don't know if PHP5 supports the > new authentication or not. > > "Soheil Noori Bushehri" <soheilnb@xxxxxxxxx> wrote in message > news:a8597fe105081707366fc20a18@xxxxxxxxxxxxxxxxx > I have used php 4.3.7 with mysql 4.0.20d on windows xp running iis 5.1 > as well as php 4.4.0 with mysql 4.1.13 on linux redhat 8.0 running apache > 2.0.54 > successfully. > > Now, I have encountered a problem on windows xp: > > php 4.4.0 (maunally-installed package) phpinfo works fine. > mysql 4.1.13 > > os: windows xp sp1 and sp2 > webserver: tried both iis 5.1 and apache 2.0.54 > > Problem: php cannot connect to mysql. Error is something like: > > > Warning: mysql_connect(): Client does not support authentication protocol > requested by server; consider upgrading MySQL client in > C:\Program Files\Apache Group\Apache2\htdocs\mysqltest.php on line 35 > > Have I missed something? Meanwhile, how could I make my php know MySQLi > (Improved MySQL) library as I haven't seen anywhere that this library is > not supported by windows? > > Thanks > > -- > Soheil Noori Bushehri > soheilnb@xxxxxxxxx > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Soheil Noori Bushehri soheilnb@xxxxxxxxx -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
