NOTE: native authentication plugin was removed from mysql 9.0

Solution:
~# brew uninstall mysql
~# brew install mysql@8.4
~# echo 'export PATH="/usr/local/opt/mysql@8.4/bin:$PATH"' >> ~/.zshrc  
~# source ~/.zshrc