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: | |
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
[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.