Skip to content

Instantly share code, notes, and snippets.

@russellf9

russellf9/mysql-setup-mac-with-sequel-pro.md

Forked from joeyklee/mysql-setup-mac-with-sequel-pro.md
Created July 9, 2021 13:57
Show Gist options
  • Save russellf9/6546a1f0be26f3ef3563316c69ca1000 to your computer and use it in GitHub Desktop.
Save russellf9/6546a1f0be26f3ef3563316c69ca1000 to your computer and use it in GitHub Desktop.
Download ZIP
Setting up mysql on mac with sequel pro and homebrew
Raw
mysql-setup-mac-with-sequel-pro.md

Setup instructions

Setting up mysql on mac with sequel pro and homebrew

MacOS high sierra 10.13.6
Homebrew version 1.7.6

Assuming you've installed homebrew...

Install mysql with homebrew

$ brew install mysql

Start your mysql server

$ brew services start mysql

you can stop the server: $ brew services stop mysql

Go through the mysql secure installation workflow

$ mysql_secure_installation

then enter all the infos, you'll set your password etc etc...

Enter the mysql command prompt & alter your user info

$ mysql -u root -p

then fill in your password

$ password: <insert your thing>

change your user info to handle this error MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found

ALTER USER '<username>'@'<localhost>' IDENTIFIED WITH mysql_native_password BY '<your_password>'
  • username: root
  • localhost: localhost
  • your_password: ************

you should be set up now + download and install sequel pro

Download and install Sequel Pro for nicer views into your databases

Using sequel pro

image of sequel pro interface

References:

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