MySQL "bad handshake" after entering password

Question

I'm having problem to connect to the remote DB from the terminal as follow

mysql -u db_user -p -h 10.100.1.100
Enter password:

afer entering password I'm getting that error:

ERROR 1043 (08S01): Bad handshake

and I can connect to the DB from a PC using MySQL Workbench.

Running MySQL Ver 14.14 Distrib 5.1.73 for CentOS6

And what version of MySQL Workbench did you try, that worked properly? — Michael Hampton, Jun 28 '19 at 21:36
5.1 and 8.0 are 4 _major_ versions apart. Although MySQL generally maintains compatibility, this is pushing your luck. — Rick James, Jun 29 '19 at 06:10
v5.1.73 is not compatible with v8.x of the workbench. You need to go back to v6.3 if you need a confirmed working version for right now. — Bee Kay, May 14 '20 at 22:22

score 1 · Answer 1 · answered Jun 29 '19 at 04:58

Is connector are compatible with your version? (if you upgraded db recently this may be case) Or Possibly bug try with upgraded version on both db and connector. I can see some similar bugs on mysql portals. Bad handshake most of the time mean both master and clients are not compatible.

MySQL "bad handshake" after entering password

1 Answers1