Learn iOS Programming Building Advance Projects - ĭISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. Kotlin Android Development Masterclass. Get 2 FREE Months of Unlimited Classes from skillshare. Scala Programming Tutorial Course ➡️ ⚫️ īootstrap Responsive Web Design Tutorial ➡️ ⚫️ Jenkins Course For Developers and DevOps ➡️ ⚫️ ★★★Top Online Courses From ProgrammingKnowledge ★★★ Mysql$ ALTER USER IDENTIFIED BY 'MyNewPass' Setting the MySQL root user password on OS X bash_profile file.Įxport PATH=$:/usr/local/mysql/bin/ The same procedure can be used for installing MySQL on Mac OS X. 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.In this post we will learn how to How To Install MySQL on Mac OS X.
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.
0 kommentar(er)
