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