SOLVED: Bad Handshake – MySQL Workbench Failed To Connect To SQL

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.

mysql-workbench-failed-to-connect-to-mysql-bad-handshake

Comments

  1. Avatar
    Marcelo June 17, 2019 at 9:17 pm

    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/

  2. Avatar
    Marcelo June 17, 2019 at 9:04 pm

    Thank you; wish I had see your post 4 hours before…

  3. Avatar
    burf April 3, 2019 at 12:16 am

    hi, what was the solution?

    • Ian Matthews
      Ian Matthews April 30, 2019 at 6:58 pm

      Use the old MYSQL Admin tool

  4. Avatar
    Romi Ardiansya April 2, 2019 at 5:42 pm

    Thankyou…

Leave a Reply to burf Cancel reply