Description:
Hello,
I encountered severe connection problems on my new machine with MySQl-Workbench community version > 6.0.8 when trying to open my stored server connections (both remote hosts and localhost). The connection attemps fail or the Workbench hangs or crashes (see "negative symptoms" below).
Affected versions (see "hot to repeat"):
The WB versions <= 6.0.8 are not affected (ALL connections SUCCEED, NO connection failures or crashes). The WB versions 6.1.4 to 6.2.4 are only partially affected (some connections fail, some succeed, only little crashes). Thus, a possible workaround is to use version 6.0.8 from http://downloads.mysql.com/archives/workbench/ .
Software properties of my machine: Windows 7 Enterprise SP1, .NET 4.6.1, MS Visual C++ Reistributable 2005 to 2013 (both x64 and x86), Microsoft EMET 5.5
The hardware properties are listed in the private comment.
Negative symptoms (I provided you sample Workbench log files and Windows System Event Log Records in the private comment):
- Opening a connetion fails (both remote hosts and localhost) with one of the following errors:
-- SQL editor could not be connected: Lost connection to MySQL server during query
-- Your connection attempt failed for user 'root' from your host to server at localhost:3306: Lost connection to MySQL server during query
-- Your connection attempt failed for user 'root' from your host to server at localhost:3306: MySQL server has gone away
- in the Windows System Event Log there are several error and crash reports like the following:
-- APPCRASH: MySQLWorkbench.exe: libmysql.dll
-- APPCRASH: MySQLWorkbench.exe: ntdll.dll
-- Application: MySQLWorkbench.exe Frameworkversion: v4.0.30319 Description: The process was terminated because of an unhandled exception. Excpetion information: Excetpion code c0000005, Exception address 5558371A Stack: empty
-- Application "MySQL": Aborted connection 6 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
-- FaultTolerantHeap: MySQLWorkbench.exe
Positive symptoms (these symptoms occurred on all tested connections and versions of the WB):
- The "Test Connection"-Check always in the "Edit Connection"/"Manage Server Connections"-Dialog always succeeds !
- I can connect to all MySQL-server-hosts via console (mysql.exe) and with other SQL-Clients (SAS and HeidiSQL).
- Deactivating Microsoft EMET doesn't solve the problem.
- Reinstalls and restarts (both servers and ) doesn't solve the problem.
- Install only the 32-bit versions (x86) of all components doesn't solve the problem.
- Installing only the components Server, Workbench, Notifier and Java-Connector (and omitting all other connectors, samples, etc.) doesn't solve the problem.
- Installing the Workbench with different versions of the full package-installer (e.g. "mysql-installer-community-5.7.15.0.msi") instead of the single installer for the Workbench doesn't solve the problem. Tested versions: 5.7.15.0, 5.7.14.0, 5.6.33.0, 5.5.52.0 .
- All signatures and/or MD5-sums of the installer-executables were validated successfully.
- The server-ports are open and the servers are listening, changing the port doesn't solve the problem.
- The MS Firewall was configured to open the ports automatically by the MySQL installer and I verified the firewall rules manually in the system control center.
- The server-hosts are all available via ping.
- The MySQL workbench is configured to use the system default proxy (from the Windows/IE proxy settings).
I tried to debug the connection problem with the following tips, with no success:
http://feed.askmaclean.com/archives/mysql-got-an-error-reading-communication-packet-errors...
- https://dev.mysql.com/doc/refman/5.7/en/communication-errors.html
-- Aborted connection 854 to db: 'employees' user: 'josh'
- https://dev.mysql.com/doc/refman/5.7/en/error-messages-server.html#error_er_aborting_conne...
I tried the following solutions, but they didn't solve the problem as well:
http://forums.mysql.com/read.php?152,636307,636307#msg-636307
- I Did edit connection->test connection,
-- result: successfully made the MySQL connection
- Restarted Workbench -> problem remains
- Restarted computer -> problem remains
- installed newest workbench version 6.3.5 CE build 201 (64 bit)
- Restarted computer -> problem remains
https://bugs.mysql.com/bug.php?id=80852
- I had already tried this out.. I can see the successful connection.. I can connect to tables and access through the windows command line also.. I am not able to do it with Workbench..
https://bugs.mysql.com/bug.php?id=78947
- 6.3.4 works for me too. click 'use the old authentication protocol' under advance tab
https://stackoverflow.com/questions/36482528/no-connection-in-mysql-workbench-6-3
- I recommend using the MySQL Installer for Windows. It installs, configures, and updates all of the MySQL components.
https://stackoverflow.com/questions/10563619/error-code-2013-lost-connection-to-mysql-serv...
- For me it was under Edit ? Preferences ? SQL Editor ? DBMS connection read time out (in seconds): 600
- Changed the value to 6000.
https://piwik.org/faq/troubleshooting/faq_183/
- wait_timeout
- max_allowed_packet
https://stackoverflow.com/questions/27746042/mysql-workbench-6-0-and-windows-8-failed-to-c...
- I simply uninstalled MySQL from my system. Then, I reinstalled MySQL through Windows Platform Installer. Also, re-installed MySQL Workbench.
- https://bugs.mysql.com/bug.php?id=71605
https://bugs.mysql.com/bug.php?id=62065
- Thanks. Installing C++ redistributable (32-bit) on win 7 (64-bit) worked for me.
Regards,
Alex
How to repeat:
I tested the following versions of MySQL Workbench:
Not affected (ALL connections SUCCEED, NO connection failures or crashes):
- 6.0.8
Parially affected (some connections fail, some succeed, only little crashes):
-6.1.4
-6.1.6
-6.1.7
-6.2.4
Fully affected (ALL connections fail, NO successes, frequent crashes):
-6.2.5
-6.3.7