How to fix "command not found: mysql" in Zsh

macos, mysql, ruby-on-rails, zsh

Solution

This was a problem within my configuration and `$PATH` variable. I followed the "How to install MySQL on Mac OS X El Capitan" tutorial to resolve this.

In my terminal, I opened up the configuration by running `vi ~/.zshrc`, then located the line to export my PATH

export PATH="..."

and appended

:/usr/local/mysql/bin

to it which resolved my issue.

Problem

I want to use MySQL with my Rails application. After successfully installing the package and seeing the option to start and stop the server from the Preference Pane, if I execute ``` mysql --version ``` I get an error from zsh: ``` zsh: command not found: mysql ``` I understand that this has something to do with my `$PATH` variable and if I display my `$PATH` I get: ``` /Library/Frameworks/Python.framework/Versions/3.4/bin:/Users/aniruddhabarapatre1/.rvm/gems/ruby-2.2.1/bin:/Users/aniruddhabarapatre1/.rvm/gems/ruby-2.2.1@global/bin:/Users/aniruddhabarapatre1/.rvm/rubies/ruby-2.2.1/bin:/usr/local/bin:/Users/aniruddhabarapatre1/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/opt/X11/bin:/usr/local/git/bin:/opt/ImageMagick/bin:/usr/local/MacGPG2/bin:/Users/aniruddhabarapatre1/.rvm/bin ``` How do I resolve this error to get Mysql up and running?

Original source