MySQL Local Setup in MAC
brew install mysql
mysql
$(brew --prefix mysql)/bin/mysqladmin -u root password root
mysql -h localhost -P 3306 -u root -p (Enter password as root to login)
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
Install Sequal Pro - https://www.sequelpro.com/
Use Socket Type to Login