Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

MySQL Workbench cannot open on Mac

Tags:

mysql

macos

mysql-workbench

MySQL Workbench on Mac (10.14) opens only for a moment and closes immediately without any (visible) error message. Re-installing it does not solve the problem.

What can I do to fix this problem?

like image 821
Phil Nguyen Avatar asked Mar 06 '20 21:03

Phil Nguyen

People also ask

How do I run MySQL Workbench on macOS?

To launch MySQL Workbench on macOS, open the Applications folder in the Finder, then double-click MySQL Workbench. It is also possible to start MySQL Workbench from the command line: Specifying options, a model file, or both is optional. For example:

Why can't I connect to Mac OS X MySQL server with MySQL-Workbench?

Go to System preferences -> MySql and check the state of your MySql instance. Show activity on this post. There may be one or multiple reasons if you are not able to connect to MAC OS X MySQL server with MySQL-workbench. When you press 'test connection' you might see this error.

Why can’t I open MySQL Workbench on my iPhone?

“MySQLWorkbench.app” can’t be opened because Apple cannot check it for malicious software. Then you are at the right place. We have a simple solution that may work for you if you have just downloaded MySQL Workbench and are trying to open/run it.

Why can't MySQL-Workbench connect to the MySQL server?

If the server instance is stopped, then MySQL-workbench won't be able to connect to the MySQL server. If you are still facing issue, then you need to check the port of the connection which you are making. Default port is '3307' and NOT '3306'. You can check it with using the following command in mysql terminal:

2 Answers

One solution worked with me:

System Preferences -> Security & Privacy -> click “Open Anyway”.

And don't forget to unlock the Lock icon at the bottom left.

enter image description here

like image 44
Mahmoud Abdelsattar Avatar answered Oct 14 '22 21:10

Mahmoud Abdelsattar

MySQLWorkbench need Python3.7 Framework in /Library/Frameworks/Python.framework/Versions

  1. brew install [email protected]
  2. sudo cp -r /usr/local/Cellar/[email protected]/3.7.12/Frameworks/Python.framework/Versions/3.7 /Library/Frameworks/Python.framework/Versions
  3. open MySQLWorkbench, it's work
like image 169
yakob abada Avatar answered Oct 14 '22 19:10

yakob abada
Sign in to Comment

Related questions

Insert data to MySql DB and display if insertion is success or failure
PHP script to import csv data into mysql
Laravel 5.3 Creating Models Returns "Field doesn't have a default value"
How can I create columns with type Date and type DateTime in nestjs with typeORM?
MySQL indexes - how many are enough?
How would I do MySQL count(*) in Doctrine2?
Hibernate_sequence table is generated
Update Field When Not Null
Mysql order items by the newest of 2 dates
Error # 1045 - Cannot Log in to MySQL server -> phpmyadmin
#1366 - Incorrect integer value:MYsql
Remove duplicates using only a MySQL query?
Represent a time with no date in ruby
Convert sql result to list python
Nodejs sequelize how to truncate a foreign key referenced table
MySQL Error 1064 when adding foreign key with MySQL Workbench
Mac terminal ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
How to add 'created_at' and 'updated_at' columns? [closed]
How to remove tabs at start and end of varchar field in MySQL?
Conflicting ports of mySQL and XAMPP

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!