Installing MySQL 8 using homebrew and then connect it by Sequel Pro

mysql_8_brew_sequel_pro.md

Follow the steps bellow to fix problem connecting MySQL 8 using a database client i.e Sequel Pro

brew update
brew install mysql
brew services start mysql

Add default-authentication-plugin=mysql_native_password to my.cnf file. This config file can be found in the location /usr/local/etc/my.cnf

mysql -uroot
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '[password]';
exit
brew services restart mysql

Then connect mysql using Sequel Pro