Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Workbench hangs/crashes while connecting to database

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.

  • OS: Windows 10
  • Mysql Workbench version: 6.3.6 CE
like image 401
iamcrypticcoder Avatar asked Apr 07 '16 18:04

iamcrypticcoder


People also ask

Why does MySQL keep freezing?

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.

Why MySQL database is not connecting?

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.

Why do I keep losing connection to MySQL server?

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.


1 Answers

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:

  1. It is slightly slower than Mysql Workbench
  2. It has an aggressive way of reminding you for an update (which disturbed me the most)

Permanant banner floating at the bottom

like image 188
Odd Avatar answered Nov 14 '22 21:11

Odd