CODEWITHSUNDEEP
mysqlmysql-workbench
iamcrypticcoder
iamcrypticcoder

Reputation: 2879

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.

Upvotes: 7

Views: 25744

Answers (3)

Catalin T
Catalin T

Reputation: 1

Problem was fixed for me after:

  • installed an older version of MySQL Workbench (metion it works also with 9.0 MySQL Server)
  • Deleted the entire MySQL folder from Program Files
  • Deleted the MySQL Workbench folder from C:\Users$yourUser\AppData\Roaming\MySQL -> Workbench

Good luck!

Upvotes: 0

Dimuthu89
Dimuthu89

Reputation: 23

Step 1. In your operating system go to the services app Step 2. In the service app look for mySQL80 Step 3. Start the service if it has been stopped Step 4. Now test the connection to see if it works

Upvotes: 0

Odd
Odd

Reputation: 613

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

Upvotes: 8

Related Questions