Cannot login to WordPress related MySQL database from iTerm
I figured it out reading the MAMP documentation. For anyone who may run into this in the future.

Just go to your iTerm and type:

 /Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot


You should be able to successfully log in. The MAMP docs helped after I realized MAMP database server is independent of what gets installed with Homebrew.