How to install Mysql 5.8 via Homebrew on MacOS Catalina (10.15.3) in 2020
- In Terminal, run:
brew install mysql
- Go to my.cnf file and in section
[mysqld]
add line:default-authentication-plugin=mysql_native_password
mysql -uroot
to log into mysql- then inside shell execute this command:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '[password]';
I'd like 3 hours of my life back, please.