Install MySQL on El Capitan using Homebrew

MySQL.md

Install MySQL on OS X El Capitan

Normally the installation of MySQL can be achieved with a single command, which executes a script provided by MacMiniVault : bash <(curl -Ls http://git.io/eUx7rg)

However, at the time of writing the script is not compatible with OS X El Capitan (10.11)

Install MySQL using Homebrew

An alternative to the aforementioned installation script is installing MySQL using Homebrew. This gist assumes you already have Homebrew installed, if not first read the article "Homebrew and El Capitan"

Make sure Homebrew has the latest formulae, so run brew update first
-OR- make sure Homebrew has MySQL version 5.6.27 as default formulae in its main repository :

• Enter the following command : brew info mysql
• Expected output: mysql: stable 5.6.27 (bottled)

Next install MySQL with : brew install mysql

###Additional configuration Open Terminal and execute the following commands :

• To have launchd start mysql at login :
  ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
• To load mysql immediately :
  launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
• Finally add the mysql directory to your PATH environment variable in .bash_profile :

export MYSQL_PATH=/usr/local/Cellar/mysql/5.6.27  
export PATH=$PATH:$MYSQL_PATH/bin

• Reload shell and type mysql -v to confirm
  Expected output : Server version: 5.6.27 Homebrew
  Quit the mysql CLI via mysql> \q

###Configure MySQL Open Terminal and execute the following command to set the root password:
mysqladmin -u root password 'yourpassword'

Important : Use the single ‘quotes’ to surround the password and make sure to select a strong password !

###Database Management To manage your databases, I recommend using Sequel Pro, a MySQL management tool designed for OS X

@nrollr thank you for this Gist. Please consider updating it for v5.7.14 as per my fork

latest seems to be just "brew install mysql" then homebrew itself outputs instructions on how to install the daemon/change the root password (FWIW)...

Alternatively, to start mysql one could also use brew services (brew tap homebrew/services):

brew install mysql
brew services start mysql

I tried mysqladmin -u root password 'yourpassword' and mysql -v -uroot -pYourpasswordhere on MACOS Sierra but still getting the error ERROR 1045 (28000): Access denied for user 'root'@'localhost' Anyone facing similar problem ?

Thank you!!

Thanks a lot

I followed the instructions thoroughly, entered mysql -v into terminal, and got a weird error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I received the same error as james-prado. All I ran was brew install mysql

This article helped me solve my problem:
http://stackoverflow.com/questions/15016376/cant-connect-to-local-mysql-server-through-socket-homebrew

is there a way to install only the cli client?

same problem as @hassanabidpk. no luck

@hassanabidpk and @tejasmanohar hope this helps.
Just type following in your terminal instead
Note : -u represent your mysql username which is root in my case and -p represent password

mysql -uroot -p
Enter password:

Seeing some people on here run into problems with using mysql -uroot -p. If you didn't set up a password, try entering a blank one.

Source: The last 5 minutes of my life.

Right after I installed it with homebrew I get this:

$ mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

UPD: mysql --version works by the way!

For those having ERROR 1045 (28000): Access denied for user 'x'@'localhost' (using password: NO) just do sudo mysql -v ...

for me everything works fine locally. but when I try to connect remotely. I get error

ERROR 2003 (HY000): Can't connect to MySQL server on '10.15.52.125' (61)

I can connect using the same user locally. I have already disabled firewall.

if you have this problem ERROR 1045 (28000): Access denied for user 'x'@'localhost' (using password: NO),
###Configure MySQL Open Terminal and execute the following command to set the root password:
mysqladmin -u root password 'yourpassword'.
And crate a alias for mi work this:
The alias create in your bash_profile in your terminal:
nano ~/.bash_profile
When open paste this:
alias mysql='/usr/local/Cellar/mysql/5.7.18_1/bin/mysql -u root -p'

yeah not working for me either...

People are likely having issues because the OP has set the path wrong. Rather than doing:

export MYSQL_PATH=/usr/local/Cellar/mysql/5.6.27  
export PATH=$PATH:$MYSQL_PATH/bin

It should be:

export MYSQL_PATH=/usr/local/Cellar/mysql/5.6.27  
export PATH=$MYSQL_PATH/bin:$PATH

... See how the $PATH is added to the end. If you don't do this when you call mysql it's going to load the version installed with OSX. You can test this by doing which mysql ... it should show /usr/local/Cellar/mysql/5.7.19/bin/mysql when you set the path correctly.

If you have this error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Type mysql -uroot -p and as password type exactly yourpassword (not your actual sudo password). It works ;)

Great document! I'm a fan of https://dbeaver.jkiss.org/ as a database GUI.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
yourpassword - doesn't work

mysqladmin -u root password 'yourpassword'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Thanks for guide.

@innokenty same for me, it was crashing for me after installing from brew and type mysql.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Just start server and works. mysql.server start then mysql

@amfische , thanks buddy!

Thank you so much!!!

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES/NO)

Solution-
While running the installation command -> bash <(curl -Ls http://git.io/eUx7rg)
system autogenerates a password, look for line 'Setting MySQL root password to '

Use this password to connect to mysql -> mysql -uroot -p

When I type in brew install mysql I am getting: mysql: macOS Sierra or newer is required. Error: An unsatisfied requirement failed this build. Anyone run into this issue? If so, what did you do to successfully install mysql?

When I type in brew install mysql I am getting: mysql: macOS Sierra or newer is required. Error: An unsatisfied requirement failed this build. Anyone run into this issue? If so, what did you do to successfully install mysql?

You need to specify an older version that is compatible with your operating system, for example:

brew install [email protected]

To see what versions are available, use this command:

brew search mysql

Thanks
Works for me

whatever version i try to install it says following

Updating Homebrew...
Warning: You are using macOS 10.11.
We (and Apple) do not provide support for this old version.
You will encounter build failures with some formulae.
Please create pull requests instead of asking for help on Homebrew's GitHub,
Discourse, Twitter or IRC. You are responsible for resolving any issues you
experience, as you are running this old version.
Error: The following formula
[email protected]
cannot be installed as binary package and must be built from source.
Install the Command Line Tools:
xcode-select --install

If I type mysql command, it says:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)