A temporary password is generated for : A:>s6r Successfully started `mysql` (label: )Įnter password: **** ALTER USER IDENTIFIED BY 'password' The initialize method will create the data dir, and also a root user with a temporary password, be sure you copy this password and then log in and change the password. $ launchctl unload ~/Library/LaunchAgents/ I solved it by initialize method and lost all database. 🍺 /usr/local/Cellar/mysql/5.7.9: 12629 files, 464MĮRROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Or, if you don't want/need launchctl, you can just run: Ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents We've installed your MySQL database without a root password. => Pouring mysql-5.7.9.el_capitan.bottle.1.tar.gz Using any kind of driver will work out of the box if you set the correct port.I get MySQL upgrade to 5.7.9 from Homebrew on OS X El Capitan (10.11.1), and got ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when start the service. NOTE A little caveat about connecting to the MySQL instances after such a setup. # These are commonly set, remove the # and set as required. Change the port of the 5.6 server - if ever you want to start both at the same time.Įdit uncomment port and change it to some other value than 3306.Run -user=root -datadir=/usr/local/var/mysql56Ĭhange the configuration to start the 5.6 version pointing to this databaseĮdit to change both /usr/local/var/mysql instances to /usr/local/var/mysql56 (I didn't put the in the folder name just in case it would cause If you want to run both in parallel on their own distinct databases, there are a few more steps to do.Ĭreate a new (separate) data directory and database for the 5.6 version My issue was that the was trying to boot the mysql 5.7 database (installed in the default /usr/local/var folder).

# Check which version of mysql is currently symlinked To verify which mysql version you're on at any time. # Unlink current mysql versionĪnd to switch back to the current version. # Install older mysql versionīrew install Start agent for older version of mysql # Start agent for current version of mysql I was using homebrew version 0.9.5 when writing this gist. Please see comments below and/or gist history for additional details. docker-compose down # or ctrl-c if service is running in foregroundĭisclaimer: Your milage may vary, I've updated this gist based on comments below but haven't tested it myself since switching to Docker.

Please visit for environment variables that you can optionally set (e.g. Instead consider adding a barebones docker-compose.yml for each project and run docker-compose up to start each project's mysql service. This gist was originally created for Homebrew before the rise of Docker, yet it may be best to avoid installing mysql via brew any longer.

Homebrew mysql client