Bug #85953 Unable to Connect to MySQL with Workbench 6.3.9 Using a Mac - OS X (10.12.3)
Submitted: 14 Apr 2017 20:07 Modified: 10 May 2017 0:07
Reporter: Philip VIllanueva Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.9 OS:MacOS (10.12.3)
Assigned to: CPU Architecture:Any

[14 Apr 2017 20:07] Philip VIllanueva
Description:
I am unable to connect to MySQL server with Workbench 6.3.9, using my Macbook Pro, running OS X (10.12.3).

The Hostname, Port and Username is set correctly.

I get the following message:

Cannot Connect to Database Server
Your connection attempt failed for user 'username' from
from your host to the server at mysql.mycompany.com:3306:
malformed packet

I also tried connecting to our VPN, and it still did not work.

I am able to connect to the MySQL server using the MySQL client in the terminal command-line.

Is there fix available?

How to repeat:
You will need to have MySQL 5.1 running, on a separate machine.
You will need the latest Macbook Pro with OS X (10.12.3).
Install Workbench 6.3.9.

Make sure the MySQL's User database has your account set up with permissions to access a database.

Set up the a MySQL Connection in Workbench, then try a testconnect or connecting.
[14 Apr 2017 21:03] MySQL Verification Team
Connected!

Attachment: bug85953.png (image/png, text), 746.30 KiB.

[14 Apr 2017 21:06] MySQL Verification Team
Thank you for the bug report. Please see prior attached screenshot.

MySQL Workbench Community (GPL) for Mac OS X version 6.3.9 CE build 10690321 (64 bit)
Configuration Directory: /Users/miguel/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.10.2
OS: macOS 10.12.x Sierra x86_64
CPU: 4x Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz - 16.00GiB RAM
No video adapter info available
[15 Apr 2017 13:30] Philip VIllanueva
The only thing I see that is different is your port is set to 3510, where my port is set to 3306.

Did you use TCP/IP for the Connection Method?
Did you change any settings in SSL and/or in the Advanced sections?
Did you make any changes within the OS?
[10 May 2017 0:07] Philip VIllanueva
There is a resolution to this.  Workbench 6.0 or high uses a different password encryption.  Therefore, if the users password, like my password. that was set using an earlier version of MySQL Server, 5.0 or older, the password need to be reset using a newer encryption.

I reset my password.  Now I do not get the 'Malformed Packet', using Workbench 6.3.9.

There should be documentation about password encryption and 'Malformed Packet' so users don't have to go through pain staking hours/days trying to resolve this easy to fix issue.