Bug #2292 mysql command line cannot access 4.1.0 from 4.1.1
Submitted: 5 Jan 2004 20:54 Modified: 6 Jan 2004 6:27
Reporter: Donny Simonton Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S1 (Critical)
Version:4.1.1 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[5 Jan 2004 20:54] Donny Simonton
Description:
Today, I installed a new 4.1.1 installation from RPM.  I installed the server and the client rpms.  I was able to connect locally just fine.  Then I tried to connect to a 4.1.0 box, and I got a weird error message when running show databases.

[root@xxxxx-master src]# mysql -hxxxxx.xxxxx.com -uxxxxxx -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 250169 to server version: 4.1.0-alpha-standard-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> quit
Bye

So I installed 4.1.1 on another server just to see if I could connect to 4.1.1 from another 4.1.1 box, and I was able to without any problems.

Then I tried to connect from 4.1.1 to a 3.23.52 box and I was able to connect to it just fine.

So it seems that 4.1.1 can not connect to a 4.1.0 box or there is some problem communicating.

How to repeat:
Install via RPM and try to connect.

Suggested fix:
Either upgrade all 4.1.0 boxes to 4.1.1 or maybe there is something I am missing.
[6 Jan 2004 6:27] Alexander Keremidarski
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

There is documented incompatible change bewteen 4.1.0 and 4.1.1 with regard of passwords handling. Please read Changes in release appendix before each upgrade.

http://www.mysql.com/doc/en/News-4.1.1.html
[6 Jan 2004 8:25] Donny Simonton
I think you missed my point.  I have read the documentation on many occasions.  I did not upgrade the 4.1.0 server, how can I connect from a 4.1.1 server to a 4.1.0 server without upgrading from 4.1.0 to 4.1.1?

That is not in the documentation.