Skip to content

Instantly share code, notes, and snippets.

@amura2406
Last active June 13, 2019 03:05
Show Gist options
  • Save amura2406/0866537b77884ff4a99f42526c7074a6 to your computer and use it in GitHub Desktop.
Save amura2406/0866537b77884ff4a99f42526c7074a6 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

chown /usr/local

sudo chown -R <username> /usr/local

Initialize the DB

unset TMPDIR
mysqld --initialize --datadir=/usr/local/var/mysql --user=<username>

Start the server

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>
@faitno
Copy link

faitno commented Aug 19, 2017

https://dba.stackexchange.com/a/130146
I found a workaround!

Stop your db. Then start it with:
mysqld --skip-grant-tables &
And then, I could finally do my upgrade:
mysql_upgrade

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment