Monard
Monard

Reputation: 435

MySQL Workbench crashes on mac os (fresh install)

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

Answers (9)

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!

Upvotes: 0

Hisan
Hisan

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

Muzzammil Farooq
Muzzammil Farooq

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

Prajwal H N
Prajwal H N

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

impulsive
impulsive

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

zeeshan07
zeeshan07

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

Marc Druilhe
Marc Druilhe

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

Matthew Buckett
Matthew Buckett

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

Suitcase Coder
Suitcase Coder

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

Related Questions