Skip to content

Instantly share code, notes, and snippets.

@joeyklee
Last active November 17, 2023 05:27
Show Gist options
  • Save joeyklee/5ada6a254804c33dbebbca4161277836 to your computer and use it in GitHub Desktop.
Save joeyklee/5ada6a254804c33dbebbca4161277836 to your computer and use it in GitHub Desktop.
Setting up mysql on mac with sequel pro and homebrew

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:

@joeyklee
Copy link
Author

joeyklee commented Oct 5, 2018

screen shot 2018-10-05 at 12 43 50

@howtomakeaturn
Copy link

thanks for the post!
very helpful!

@khakimjanovich
Copy link

mysql said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found

@jatin-ranka
Copy link

Thanks for the post. It was helpful.

@basketbla
Copy link

Thank you! Extremely helpful!

@corysimmons
Copy link

Thank you @joeyklee !

@erma4ina
Copy link

thanx a lot!

@redmond2742
Copy link

redmond2742 commented Nov 17, 2023

ALTER USER '<username>'@'<localhost>' IDENTIFIED WITH mysql_native_password BY '<your_password>';

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