Reputation: 435
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!
Upvotes: 37
Views: 42071
Reputation: 19
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.
I have found two practical ways of solving it:
I have verified both of the methods and both seem to solve the problem.
To downgrade or install and earlier version of MySQL, you'll simply have to uninstall it from the System Preferences Tab,
Then go to the downloads section on the website at https://dev.mysql.com/downloads/mysql/ And, select the earlier version from the drop-down menu or you can look for a specific version from the archives tab. And then simply install it, and it should fix the problem.
The next option would be installing it with HomeBrew. Although it worked, but I wouldn't recommend this method because of a few reasons. 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.
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!
Upvotes: 0
Reputation: 2645
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.
Upvotes: 5
Reputation: 21
uninstall current version and re download 8.0.31 version from this link : https://downloads.mysql.com/archives/workbench/ working fine no more crash
Upvotes: 1
Reputation: 69
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.
Upvotes: 7
Reputation: 1
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.
Upvotes: 0
Reputation: 79
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.
Upvotes: 1
Reputation: 19
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)
Upvotes: -1
Reputation: 4371
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
Upvotes: 76
Reputation: 151
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.
Upvotes: 13