Setup Mysql On MacOS
Install MySql Server On MacOS
Official installation guide: Installing MySQL on macOS Using Native Packages
Once MySQL is installed, you can find MySql in System Preference. Quit and Restart System Preference if cannot find MySQL in System Preference.
Initialize MySql Database to set the password of root user.
Install MySql Management Tool
Install MySQL Workbench:
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
MySQL workbench may uses legacy password encryption to connect to the DB server. Can also be done while installing MySQL and choosing the Legacy encryption, instead of the recommended Strong password encryption. Got Error:
Failed to Connect to MySQL at 127.0.0.1:3306 with user root
Authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found