can't access mysql from command line mac

mysql terminal
Michael Insalaco picture Michael Insalaco · Nov 19, 2011 · Viewed 169.1k times · Source

mysql on os x 10.6 is located in /usr/local/mysql/bin/mysql

I get command not found when I type mysql --version in the terminal. Is this because the socket path is wrong? if so how do I fix it?

thanks

Answer

sascha picture sascha · Nov 19, 2011

Just do the following in your terminal:

echo $PATH

If your given path is not in that string, you have to add it like this: export PATH=$PATH:/usr/local/ or export PATH=$PATH:/usr/local/mysql/bin

Related questions

Mac install and open mysql using terminal

I downloaded the mysql dmg file and went through the wizard to run. Done. I have also started mysql server under system preferences. The purpose of me doing this is to work through the exercises of my SQL text book. …

Read More
How do I install command line MySQL client on mac?

I want to install the MySQL client for the command line, not a GUI. I have searched over the web but only found instructions on installing the MySQL server.

Read More
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I am trying to run mysql client on my terminal. I have installed the latest mysql gem. ➜ ~ git:(master) ✗ ruby -v ruby 1.8.7 (2010-01-10 patchlevel 249) [universal-darwin11.0] ➜ ~ git:(master) ✗ rails -v Rails 2.3.14 ➜ ~ git:(master) ✗ which mysql mysql: aliased to nocorrect mysql ➜ ~ …

Read More