I'm trying to setup up MySQL on mac os 10.6 using Homebrew by brew install mysql 5.1.52. Everything goes well and I am also successful with the mysqlinstalldb. However when I try to connect to the. MAMP creates a local server environment on Mac OS X by installing PHP, MySQL, and Apache right out of the box. This will make Drupal much. Installing Drupal 7 on Mac OS X 10.13 (High Sierra) Install Drupal7 in macOS High Sierra (10.13.6) Postgres on Max OS X with MAMP.
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?
Install Apache Mysql Php On Macos Catalina
SQL Server is a relational database management tool developed by Microsoft. It is available on Windows, Linux, macOS, and as a Docker deployment. In this tutorial, we will show you how to install SQL Server 2019 as a Docker deployment on macOS Catalina. Before Installing MySQL Workbench on macOS. Before installing the MySQL Workbench, make sure you have access to the database. It is either db in your local system or it could be a remote database in your hosting server or even cloud database such as AWS RDS. In this post, I will be using local MySQL server as an example.
Install Mysql On Mac 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.