![]() ![]()
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). #Install mysql for mac os sierra install#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. Version info: CRMPiccos-MacBook:log crmpicco$ mysql -version => Successfully started `mysql` (label: ) When I start MySQL with homebrew I get no error: CRMPiccos-MacBook:~ crmpicco$ brew services start mysql ![]() This is how I initialised MySQL: mysqld -initialize -verbose -user=`whoami` -basedir="$(brew -prefix mysql)" -datadir=/usr/local/var/mysql #Install mysql for mac os sierra driver#If the JDBC driver for MySQL is not installed on. This tutorial uses the MySQL Connector/J 5.1.46 driver to connect to a MySQL Version 5.5.16 database. #Install mysql for mac os sierra how to#I had to create a var/log/mysql/error.log as it wasn't created automatically, however now it is logging I get the following error when I do a rver start: T13:36:28.554840Z 0 Can't open the ugin table. This tutorial shows how to set up a data source and connect to a MySQL database using the Database Explorer app or the command line. I had a previous (non-functioning) install of MySQL so I followed the steps here to install a clean copy with Homebrew. I am attempting to install MySQL on macOS Sierra 10.12.5. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |