Setting up MySQL on a Mac using Sequel Pro and Homebrew

Sequel Pro and Homebrew

Open terminal in root directory…

Assuming you’ve installed homebrew skip…

$ /bin/bash -c “$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)”

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 info, you’ll set your password 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 at

https://sequelpro.com/

I don’t know if the main site download app build errors have been fixed, but just in case you encounter any errors here is an alternate build with no errors

Alternate download link for dark mode stable build

Password Validation Allowed (optional) :

Then check if the password validation policy has been changed to low:

mysql> SHOW VARIABLES LIKE ‘validate_password%’;

Sample output:

+ — — — — — — — — — — — — — — — — — — — + — — — -+

| Variable_name | Value |

+ — — — — — — — — — — — — — — — — — — — + — — — -+

| validate_password.check_user_name | ON |

| validate_password.dictionary_file | |

| validate_password.length | 8 |

| validate_password.mixed_case_count | 1 |

| validate_password.number_count | 1 |

| validate_password.policy | LOW |

| validate_password.special_char_count | 1 |

+ — — — — — — — — — — — — — — — — — — — + — — — -+

7 rows in set (0.00 sec)

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store