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

Leave a Reply

Your email address will not be published. Required fields are marked *