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
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)
