MySQL “bad handshake” after entering password

MySQLmysql5

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

Best Answer

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.

Related Solutions

Mysql – Tunnel to MySql via workbench not working when regular ssh tunnel works

You're doing your ssh forwarding backwards, i.e. you're forwarding local port 3306 to 33187, use -R localhost:33187:server.domain.com:3306. For the workbench use MySQL Server Port 3306 and MySQL Hostname: localhost

What specifically is the error you're getting, I'm having a problem myself using a custom ssh port, i.e. SSH Hostname server.mydomain.com:13711 the workbench for whatever reason doesn't actually attempt a connection (verified by watching the logs)

Mysql – How to allow MySQL Remote Access from a dynamic IP

You should try to use the "%" for the host part. Something like:

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

(Taken from MySQL Documentation)

Make sure that the changes take effect properly with:

flush privileges

Best Answer

Related Solutions

Mysql – Tunnel to MySql via workbench not working when regular ssh tunnel works

Mysql – How to allow MySQL Remote Access from a dynamic IP

Related Topic