Solution: Need to set correct path for terminal
This is the problem with your $PATH:
/usr/local//usr/local/mysql/bin/private/var/mysql/private/var/mysql/bin.
$PATH is where the shell searches for command files. Folders to search in need to be separated with a colon. And so you want /usr/local/mysql/bin/ in your path but instead it searches in /usr/local//usr/local/mysql/bin/private/var/mysql/private/var/mysql/bin, which probably doesn’t exist.
Instead you want ${PATH}:/usr/local/mysql/bin.
So do
export PATH=${PATH}:/usr/local/mysql/bin.
If you want this to be run every time you open terminal put it in the file .bash_profile, which is run when Terminal opens.
reference:
https://stackoverflow.com/questions/10577374/mysql-command-not-found-in-os-x-10-7
Problem: The above mentioned .bash_profile edit will not work
Solution
After Mac version upgrades, .bash_profile will not work. Need to place the export path to the .zshrc file instead.
nano ~/.zshrc
Solution
Another solution is Just added "source ~/.bash_profile" to my .zshrc and everything is working fine now even when I open new tabs.