if i have mysql 5 client installed on my local computer and i try to
connect to a mysql server with mysql 4.1, is this expected to give
errors? like lost connections?

>if i have mysql 5 client installed on my local computer and i try to
>connect to a mysql server with mysql 4.1, is this expected to give
>errors? like lost connections?

Mismatched server and client versions that are not "too far apart"
generally work fine.

They have changed the password hash algorithm. Mismatches across
these boundaries generally fail to log in and get an error message
to that effect ("Access denied" or "Client does not support
authentication protocol"). If both server and client are at version
4.1.1 or greater, this should not be a problem.

A "lost connection" when it is not explainable by a connection
idle-timeout often means "mysqld dumped core". mysqld may be
restarted by mysqld_safe.

tommy <wheels619@gmail.com> wrote:
> if i have mysql 5 client installed on my local computer and i try to
> connect to a mysql server with mysql 4.1, is this expected to give
> errors? like lost connections?

Why don't you just try?

But the answer is: no there are no problems to be expected. The MySQL
protocol is backwards compatible, so as long as the client is newer or
equal version than the server, all is fine.

There is even (nearly perfect) forward-compatibility. The protocol
changed a lot with 4.1. But still older clients (3.23, 4.0) work
with new servers because both sides announce their capabilities at
handshake.


XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/