Running a MySQL server using Homebrew#

First, install MySQL like so:

1
brew install mysql

This installs the server but doesn’t run it. You can run it in the background like this:

1
% mysql.server start
2
Starting MySQL
3
.. SUCCESS!
4
%

Then later on you can stop it like so:

1
% mysql.server stop
2
Shutting down MySQL
3
. SUCCESS!
4
%

While it’s running it defaults to having a root account that only accepts connections from localhost with no password:

1
% mysql -u root
2
Welcome to the MySQL monitor.  Commands end with ; or \g.
3
Your MySQL connection id is 8
4
...
5
mysql>

Running mysql_secure_installation runs a wizard that helps set up a password.

When you first install it, Homebrew says:

1
To have launchd start mysql now and restart at login:
2
  brew services start mysql

You can re-display that message by running brew reinstall mysql.

1
MYSQLCLIENT_CFLAGS=`pkg-config mysqlclient --cflags` \
2
  MYSQLCLIENT_LDFLAGS=`pkg-config mysqlclient --libs` \
3
  pip install mysqlclient