MySQL Workbench crashes on mac os (fresh install)
Asked Answered
L

9

37

I installed mySQL workbench and I can't open it, it crashes right away. SQL is installed, I can access databases in my terminal. The sql server is running. Im on mac os 11.1

I researched this topic, I found that a plugin can cause this, but I don't even have that plugin in my files.

Time Awake Since Boot: 890 seconds

System Integrity Protection: enabled

Crashed Thread:        0  Dispatch queue: com.apple.main-thread

Exception Type:        EXC_CRASH (SIGABRT)
Exception Codes:       0x0000000000000000, 0x0000000000000000
Exception Note:        EXC_CORPSE_NOTIFY

Termination Signal:    Abort trap: 6
Termination Reason:    Namespace SIGNAL, Code 0x6

Thanks in advance if you could help!

Lightfoot answered 19/1, 2021 at 19:58 Comment(6)
I could never make MySQL Workbench run stable on my Mac. Choose a different tool. There are more then enough on the marketPerspicacious
I guess I'll go choose another one than.. I only wanted this because we use it in school (on windows pc-s). Thanks for the reply!Lightfoot
MySQL Workbench switched to Python 3, maybe that is the culprit?Linell
I installed python 3 but still gives me the same error.Lightfoot
There's the same report here: #65792936Valerievalerio
Had the same issue, try and restart your server with mysql.server stop; mysql.server startSalubrious
V
76

MySQLWorkbench 8.0.23 crashes for me on startup on macOS 11.1, but downgrading to 8.0.22 from MySQL archives allows it to startup without a problem.

This bug is reported to the MySQL bug tracker: https://bugs.mysql.com/bug.php?id=102284

Valerievalerio answered 20/1, 2021 at 16:49 Comment(10)
Same issue on macOS Catalina 10.15.7. Upvoted, downgrading to 8.0.22 works fineBaryta
ditto on what Nick said.Christ
Omg, we use this tool at our university, it is so buggy. Thanks for your suggestion.Irritative
thanks a lot. I had the same problem with 10.15.7. After downgrading it worked.Bitchy
The suggested 8.0.22 version crashes at startup, too :( I'll have a look for alternatives, I have no time for that...Isopropyl
Can confirm that 8.0.23 crashes on MacOS BigSur 11.2.2, downgraded to 8.0.22 and it works fine. downloads.mysql.com/archives/workbenchPhenothiazine
MySQL Workbench 8.0.24 had been released and this appears to startup correctly for me on macOS Big Sir 11.2.3Valerievalerio
same issue with Ventura 13.2: downgrade to 8.0.23 works fineAltazimuth
I had issues with 8.0.32, after downgrading to 8.0.31, crashing issue has been resolved.Fibula
using M2 Chip from Apple, MacOS 14.2.1, facing the crashing issue with every MySQL Workbench version. I've tried several versions, none of them could fulfill my migration...Heracles
C
13

I was having the exact same issue, I was able to download the older version from MySql's archives, and it worked for me.

P.S., I also had to go into System Preferences > Security & Privacy > General and open anyway for MySQL.

Cortex answered 3/2, 2021 at 19:21 Comment(0)
H
7

Faced the similar problem on my Mac, but workbench crashed every time I run the query. Solved the issue by degrading the versions.

I used 8.0.32. But after installing 8.0.31, workbench won't crash anymore.

Headwards answered 22/2, 2023 at 10:3 Comment(0)
L
5

In my case, downgrading from 8.0.32 to 8.0.31 did the trick.

Go to the product archives here and you'll be able to find it.

Link: https://downloads.mysql.com/archives/workbench/

This should solve the problem for you.

Legendary answered 22/3, 2023 at 12:27 Comment(3)
Please don't duplicate existing answers, unless you want to share new insightsCockneyfy
@NicoHaase I added the link to the archive to download the exact version. I'll call this newLegendary
What exactly is new in that? That link was already posted three times within this questionCockneyfy
F
1

I was having this crash issue on my mac Monterey 12.3 with the latest Mysql workbench 8.0.31, So I uninstalled it and did a fresh install of lower version 8.0.27. And it is working fine now.

Fayefayette answered 6/2, 2023 at 6:0 Comment(0)
F
1

uninstall current version and re download 8.0.31 version from this link : https://downloads.mysql.com/archives/workbench/ working fine no more crash

Fontanez answered 2/3, 2023 at 22:56 Comment(1)
Please don't duplicate existing answers, unless you want to share new insightsCockneyfy
V
0

As many people suggested, downloading and using the previous version may help resolve the issue. I encountered an error while using version 8.0.31, so I downloaded version 8.0.30 and to my surprise, the problem was fixed.

Virchow answered 16/2, 2023 at 21:17 Comment(0)
T
0

From the answers above, it looks like running MySQL on Mac has not been a smooth task. As I am attempting to learn SQL and MySQL, I too faced the error of it quitting unexpectedly. MySQL Workbench quits unexpectedly while launching the MySQL Connection.

I have found two practical ways of solving it:

  1. Downgrade to an earlier version of MySQL
  2. Install it using HomeBrew

I have verified both of the methods and both seem to solve the problem.

Downgrade to an earlier version of MySQL

To downgrade or install and earlier version of MySQL, you'll simply have to uninstall it from the System Preferences Tab,

enter image description here

Then go to the downloads section on the website at https://dev.mysql.com/downloads/mysql/ enter image description here And, select the earlier version from the drop-down menu or you can look for a specific version from the archives tab. enter image description here And then simply install it, and it should fix the problem.


Installing using HomeBrew

The next option would be installing it with HomeBrew. enter image description here Although it worked, but I wouldn't recommend this method because of a few reasons. enter image description here You won't have a GUI access to MySQL from the System Preferences like you did with the earlier method and you will have to go an extra step to configure the password and other preferences.


NOTE: One thing that I'd like to point out is that, if you have Anaconda Distribution installed, but can also be the reason of the problem because of version conflicts and all, but it is just my assumption. enter image description here

If none of these work, one last option would be a system reset and even that does not work, you can try downgrading your macOS version as I read somewhere that I also maybe causing some issues, but I hope you won't have to encounter this situation.

Good Luck!

Trochelminth answered 6/5 at 14:44 Comment(0)
Z
-1

I had the same problem (macOS BigSur 11.6.3) : could not upgrade to any v8.x version. After further investigation, I found that I was having a user module (script I wrote several years ago to generate automatic documentation). After removing it from the 6.3 version (menu : Scripting > Scripting shells > Files > User module) I was able to install and run MysqlWorkbench 8 (8.28 for instance)

Zhang answered 17/2, 2022 at 14:33 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.