Install Mysql On Mac Catalina

admin

  • Localhost install on MacOS Catalina (mac mini 2012) running Mac Apache & PHP 7.3.22 + Homebrew MySQL 8.0.21
    Apache is running, MySQL is running (I have accessed via command line and checked my username, password, and Privileges). I have confirmed that wp-config.php contains the same info as the database itself reports. (which is the only clue given on the error page)
    Yet I STILL get “error establishing database connection” when trying to install.
    ps-ef | grep mysql shows mysql reporting its hostname as something odd that includes both the mac machine name plus the network or router name. Don’t know if that could be a clue?

    Any help would be appreciated

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. (MySQL 8 is relatively new and not in many production set ups) One thing with MySQL upgrades, always take a data dump of your database in case things go south and before you upgrade to macOS Catalina make sure your MySQL Server is not running. Brew install mysql56 instead of brew install mysql. Bundle installing the mysql2 gem kept failing, until: brew link mysql56. I also ran afterwards: mysql.server start. The last step might be unnecessary, but just in case. 5: With Mac OS 10.15 Catalina when I tried Alessandro’s fix the gem and extensions could be installed.

Install

  • Hello @jredmond,

    Could you please share the details of the error page or any error logs you might have?

    In your wp-config.php file, is your DB_HOST set to localhost or the hostname reported by MySQL?

    You’re welcome. Glad it’s fixed now.

    If your question has been answered, it would be great if you would mark this topic as resolved in the sidebar. This helps the forum’s volunteers find the topics that still need attention and more people will get helped, possibly like you did.

    @jredmond Hi there. Could you please leave a trace of what you did to fix it? This might help many people, and me too, obviously.
    Thanks, ciao.

  • The topic ‘5.5 MacOS Catalina install – error establishing database connection’ is closed to new replies.

Install Apache Mysql Php On Macos Catalina

Install mysql on mac catalina

How To Install Mysql On Macos Catalina


Posted by: Paul Johnson
Date: October 14, 2020 09:34PM

My directory structure is different than yours. What I'm surmising is that an error log created by MySQL would provide useful information. I'm using 'locate' to find files and directories containing mysql.
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 Mysql On Mac Catalina Free


Install Mysql On Mac Catalina Os

Options:Reply•Quote

Written By

Sorry, only registered users may post in this forum.

Install Mysql 5.6 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.