[Jason L]

Using Apache 1.3.31, PHP 4.3.8 and MySQL 4.1.10 on Win XP home edition. Prior to MySQL 4.1.10, I was using MySQL 4.0.18. The PHP scripts were able to connect to the database. After the upgrade, PHP scripts can't connect to the database.

Are there any specifications for MySQL 4.1.10 to work with PHP/Apache???

I would like to try to solve this before using the "System Restore" option.

TIA

Jason

[greybird]

What error do you get?

[moronovich]

maybe your php script uses mysql extension. for mysql 4.1.x and up, this extension doesn't work. instead, you should use mysqli or the beta version PDO.

anyway, if you're not experienced enough with php (or to modify whole scripts), i suggest you rollback the change and upgrade your mysql to 4.0.2x

regards,

[Jason L]

Thank you all for the replies.

Modified the scripts to print out the error message

"Client does not support authentication protocol requested by server; consider upgrading MySQL client ... "

Did a google on it, "MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients"

" Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); "


Time for me to read more documentation on MySQL 4.1.10....

Once again, thank you for the replies.