And after that you must now press on the apple symbol which is located from the uppermost top right part of the screen, then after which you must tap on the option “ About This Mac”.

To get started you must first, look at what versions of Mac you were using on.How to Configure MySQL on Mac for the Terminal Application Part 1. Through the conclusion of just this article, you should have been able to install the MySQL domain controller onto your Mac enabling local production.Ĭontents: Part 1. Then MySQL should continue to accept non-local connections from then on - until you reinstall it, presumably.Įdit (Sep 2019) Timothy Zorn points out that this problem no longer occurs for MySQL 8.x installed and run via Homebrew, so my answer above, written in 2016, may only be relevant to 5.x.How to install MySQL Mac? Although Mac OS somehow doesn't include something like a pre-configured version of MySQL, these step-by-step instructions would make the whole thing simple for everyone. Restart mysql using brew services restart mysql.Edit /usr/local/Cellar/mysql// and replace -bind-address=127.0.0.1 with bind-address=* or -bind-address=0.0.0.0 ( see MySQL documentation on bind-address).

So better advice than what I originally wrote is the following:

I feel this is a vital piece of information that was lacking from most of the resources I consulted so hopefully posting this here will help someone else!ĮDIT: As LeandroCR indicated in the comments, running brew services restart mysql will overwrite the plist file in LaunchAgents with the default one, leading to MySQL mysteriously refusing connections again. It wasn't until I ran ps -ax | grep mysql and noticed that the bind address was being passed in the launch command (thus overriding any my.cnf files) that I dug some more and found out that Homebrew binds MySQL to 127.0.0.1 by default.Įditing ~/Library/LaunchAgents/ to change -bind-address=127.0.0.1 to -bind-address=0.0.0.0 solved my problem (the latter should be changed to a specific IP address if this isn't just a development machine). I even removed and reinstalled MySQL following these instructions and then reinstalled using brew install mysql. Following suggestions on StackOverflow and elsewhere, I hunted around after my.cnf files all of which specified bind-address=0.0.0.0. I have been banging my head against this error today on OSX Yosemite with MySQL 5.7 recently updated with Homebrew.

How to run mysql on mac