Setting up mysql on mac with sequel pro and homebrew

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

References:

• https://www.youtube.com/watch?v=ltYNt44c2xo

thanks for the post!
very helpful!

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

Thanks for the post. It was helpful.

Thank you! Extremely helpful!

Thank you @joeyklee !

thanx a lot!

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