I want to run some
mysql command from my terminal, but each time I run mysql -u root to log in, I
get an error:
command not found
This is because
mysql isn’t in my PATH. Your path is an
environment variable that holds directories that your computer will search
through to find executable files. You can review what’s in your path by
# echo $PATH
This will show you
the list of directories that are in your path.
This variable is stored in your .bash_profile. On most macs, the
.bash_profile file is located in the root of your home directory. To view the
current .bash_profile file, go to your home directory
From there, run the
ls command to view all files.
# ls -alh
Near the top of the listing is the
.bash_profile file. Cat out the contents to see what’s in your path.
# cat .bash_profile
To update the file,
backup your current .bash_profile
# cp .bash_profile .bash_profile_backup
To locate your mysql
executable, use the locate command.
# locate mysql | less
Since I’m running
MAMP, my mysql executable is located in
To add this to the end my path, run the following command.
# echo 'export
PATH=$PATH:/Applications/MAMP/Library/bin' >> ~/.bash_profile
This takes the
output of the echo command and puts it into your .bash_profile. Now, you make
it persist by sourcing it. This alerts the current terminal to reload the file.
# source ~/.bash_profile
Now you can echo
path again to confirm or cat out your file
# echo $PATH
Now, we can use the
mysql command from our current location. Enter the password, if prompted.
# mysql -u root -p
Now, you can run
your commands with ease.
To quit the mysql