MySQL Bugs: #79081: Connection successful, cannot to database.

Bug #79081	Connection successful, cannot to database.
Submitted:	2 Nov 2015 20:47	Modified:	1 Jul 2017 22:01
Reporter:	George Dietrich	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	6.3.6	OS:	Windows (When connecting to mySQL server running raspbian)
Assigned to:		CPU Architecture:	Any

Description:
Recently when trying to connect to my SQL server thru SSH it gives me the error that it "Cannot connect to database server."  The database is hosted on a raspberry pi running Rasbian-Jesse.  It is on the same network as the computer that I'm trying to connect from. 

I know for sure that the database is running, as I can connect to it using command line and the queries work on my website.

Things I have tried:
Restarting the server
Restarting the pi itself
Restarting computer
Changing ports
Disabling antivirus
Connecting from different users
Using different versions of workbench
Complete reinstall of Rasbian, MySQL and Apache on the pi. 

However, when I go to edit the connection and click Test Connection it comes back saying "Successfully made the MySQL connection with the parameters defined for this connection."  Yet when I go to actually connect it gives the error.  

How to repeat:
It seems to replicate this; have most current workbench version and try to connect with (cant speak about other versions, but) 5.5.44 MySQL server.  

Suggested fix:
Since it has worked for months previously it may be an issue with something to do with workbench no supporting older versions of mySQL, as i'm pretty sure it started when I upgraded the version on the pi.

Log file

Attachment: wb.log (application/octet-stream, text), 7.94 KiB.

I couldn't repeat this issue connecting with a CentOS 6.5 running 5.1.73 server according with your log you tried to connect with root user please setup another user and try it. Thanks.

Log File - New user

Attachment: log.txt (text/plain), 8.14 KiB.

I made a new user, granted all privileges and then tried again.

Once again, test connection was successful while actually connecting gave the error.

I uploaded the new log

Thank you for the feedback. Please see last comment from https://bugs.mysql.com/bug.php?id=74658. Try 32 bit version. Thanks.

Log File 3

Attachment: Log File 3.txt (text/plain), 10.45 KiB.

Uninstalled the 64 bit version, installed 32 bit and same problem.  

New log file is attached as well.

http://bugs.mysql.com/bug.php?id=81459 marked as duplicate of this one.

Today I ran into a similar problem in a more simple setup, eg. no raspberry, no ssh, but a simple connection over TCP 127.0.0.1 and running mysqld on Windows.

In the end it appeared that Workbench ONLY would connect when started 'as administrator'. Without elevated rights, it would not connect. Even if I disabled the firewall.

Please try version 6.3.9. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".