I migrated to Windows 10 from Windows 7 few days ago. After installing mysql workbench I have tried to connect to local mysql server and AWS RDS server too. Every time I click "Test Connection" button it crashes. After few googling I saw this bug is reported here: https://bugs.mysql.com/bug.php?id=69572
But solution is not clear from above thread or I didn't get it. If anybody knows solution please let me know. I am tired to find solution of this bug.
The most common cause of crashes in MySQL is that it stopped or failed to start due to insufficient memory. To check this, you will need to review the MySQL error log after a crash. First, attempt to start the MySQL server by typing: sudo systemctl start mysql.
normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.
The error above commonly happens when you run a long or complex MySQL query that runs for more than a few seconds. To fix the error, you may need to change the timeout-related global settings in your MySQL database server.
Strangely, after an upgrade, MySql Workbench crashed each time it connected to Server. As a quick fix, I deleted the connection and added a new one. Unexplainable, but it worked.
Database > Manage Connections > Delete (similarly create new connection)
After I faced some serious issues combining MySql Workbench with MariaDB, I've switched over to TeamSQL. It is free and works well straight out of the box. However, it comes with a cost of two drawbacks:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With