Re: Version compatible of mysql(v3.23) to mysql(v4.1/v5)

[Chis Florinel]

One common problem:
" MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail with the following message:
Client does not support authentication protocol requested
by server; consider upgrading MySQL client"

See
http://dev.mysql.com/doc/mysql/en/old-client.html

mysqli extension for php has functions compatible with mysql 4.1 for auth, transactions, etc...