Skip to content

Instantly share code, notes, and snippets.

@r-martins
Forked from amura2406/IntallPerconaOSX.md
Last active May 30, 2022 18:29
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save r-martins/af78b223f06fd5dde63e81a531e10e45 to your computer and use it in GitHub Desktop.
Save r-martins/af78b223f06fd5dde63e81a531e10e45 to your computer and use it in GitHub Desktop.
Steb-by-Step to Install Percona Server (Alternative to MySQL) on Mac OS X 10.11.6 (El Capitan)

Install percona-server.

Install from homebrew

brew install percona-server

Initialize the DB

unset TMPDIR
mysqld --initialize --datadir=/usr/local/var/mysql --user=<username> --port=3307 --general-log-file=/var/log/percona/percona-error.log

Start the server

/usr/local/Cellar/percona-server/5.7.20-19/bin/mysql.server start

Change root password (Optional)

mysql will create temporary password for you and show it in the output of mysql.server start. To change it

mysqladmin -u root -p'<temp_password>' password '<new_password>'

To check whether it is working

mysql -u root -p
<Type in password>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment