This issue came up when I recently restarted my MacBook.
MySLQ was installed to my Mac using Homebrew, so I checked the whether MySQL is running using the following command
It showed that the service is running. So I went to mysql installation folder and ran the following command.
sudo mysql.server start
This gave me the following error.
dyld: Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
Referenced from: /usr/local/Cellar/mysql/8.0.15/bin/my_print_defaults Reason: image not found
I decided to reinstall
openssl and ran the following command.
brew uninstall openssl
This gave me another error.
Error: Refusing to uninstall /usr/local/Cellar/openssl/1.0.2t
because it is required by apr-util, curl-openssl, freetds, glib, httpd, krb5, libevent, libpq, libssh2, mysql, nghttp2, nginx, openldap, php, python, [email protected] and rtmpdump, which are currently installed.
So I updated the homebrew and tried to uninstall
brew update && brew upgrade brew uninstall --ignore-dependencies openssl
After removing openssl, I reinstalled it. You can install openssl using one of the following commands.
brew install https://github.com/tebelorg/Tump/releases/download/v1.0.0/openssl.rb brew install openssl
Final step was to link openssl. To link openssl, run the following command.
brew link openssl
Thats it. I was able to connect to MySQL using MySQL Workbench. Hope this helps.