Elated, I moved back to the System Preferences for MySQL, and after happy feelings at seeing the two green dots (indicating success), I tried to stop MySQL by clicking on the button labelled 'Stop MySQL Server'. Bug #101711: MySQL Workbench 8.0.22 and MacOS Catalina 10.15.7: Apple cannot check malicious: Submitted: 22 Nov 2020 18:19: Modified: 22 Nov 2020 18:46. Hello Friends,In this video tutorial, you will learn to install MySql workbench 8.0 on mac os x Catalina. I have explained the whole process of installation.
Installed MySQL 8.0.18 from a dmg file downloaded from the official site. The service won't start when manually started from the new Preferences icon added by the installer. Running sudo /usr/local. The MySQL JDBC Driver makes it easy to access live MySQL data directly from any modern Java IDE. After configuring the connection, explore the tables, views, and stored procedures provided by the MySQL JDBC Driver. These constructs return live MySQL data that developers can work with directly from within the IDE.
Date: October 14, 2020 09:34PM
Anyway, I proceeded on a path related to an ownership issue:
I found this link:
https://stackoverflow.com/questions/41995912/macos-cant-start-mysql-server
On that page I found one post by Jack BeNimble suggesting the following ownership change:
sudo chown -R _mysql:wheel /usr/local/mysql/data
Being the gambler that I am, I tried it. (Changing group from _mysql to wheel)
Lo and behold, manually starting MySQL was successful using:
sudo /usr/local/mysql/support-files/mysql.server start
Elated, I moved back to the System Preferences for MySQL, and after happy feelings at seeing the two green dots (indicating success), I tried to stop MySQL by clicking on the button labelled 'Stop MySQL Server'. Sadly, it gave me the 'legacyLoader wants to make changes' message (to which I responded by entering my system password). This didn't stop MySQL.
So... I tried manually stopping MySQL in Terminal with:
sudo /usr/local/mysql/support-files/mysql.server stop
It worked! And in the System Preferences for MySQL, the red dots showed MySQL was down.
Now the problem has been reduced to the getting the 'Start/Stop MySQL Server' button to work.
Another ownership problem perhaps? Or maybe something more complicated because of changes in Catalina.
More fundamentally, why am I having these problems when I'm basically trying to do a vanilla install?
Catalina Mysql Path
Mysql Catalina
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.