If you see FAILED TO CONNECT TO MYSQL – BAD HANDSHAKE in MySQL Workbench, your database is likely unsupported. MySQL Workbench only supports MySQL databases version 5.1 and newer.
Fortunately there is an easy way around this. Use the old MYSQL ADMINISTRATOR tool as shown below. In my case I was trying to open a MySQL 5.1 database for a clients WordPress installation with MySQL Workbench 8 and that did not work out :).
You can download MySQL Administrator (aka. MySQL GUI TOOLS) directly from the good people at MySQL HERE.
This website uses cookies.
View Comments
If I had known your solution, i'ld not have lost 4 hours !
Reinstalled MySql Workbench 6.3 and all is fine.
Thank you for solution :o)
Marcelo, Workbench 6.3 worked for me too, thanks man.
Ahn, BTW I forgot to mention that previous editions of Workbench function with MySQL 5.1... I installed the 6.3 version, downlaoded @ https://dev.mysql.com/downloads/workbench/
Thank you; wish I had see your post 4 hours before...
hi, what was the solution?
Use the old MYSQL Admin tool
Thankyou...