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?
-
comnand not found means it's not in your path. If it was a socket problem, you'd get "unable to connect" or something similarMarc B– Marc B2011-11-19 16:29:10 +00:00Commented Nov 19, 2011 at 16:29
-
possible duplicate of Mysql command not foundSahil Kapoor– Sahil Kapoor2015-06-29 12:29:05 +00:00Commented Jun 29, 2015 at 12:29
-
possible duplicate of Using Mysql in the command line in osx - command not found?kishanio– kishanio2015-08-17 09:16:27 +00:00Commented Aug 17, 2015 at 9:16
Add a comment
|
8 Answers
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
6 Comments
Michael Insalaco
I tried doing both. When i echo $PATH it still says -bash: /Users/minsalaco/.rvm/gems/ruby-1.9.3-p0/bin:/Users/minsalaco/.rvm/gems/ruby-1.9.3-p0@global/bin:/Users/minsalaco/.rvm/rubies/ruby-1.9.3-p0/bin:/Users/minsalaco/.rvm/bin:/Applications/MAMP/Library/bin:/Applications/MAMP/Library/bin:/Applications/MAMP/Library/bin:/Applications/MAMP/Library/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/local/git/bin:/usr/X11/bin: No such file or directory
Michael Insalaco
i removed MAMP and just want to use mysql from the command line
sascha
Please read my answer once again. I just told you how to fix your issue.
/usr/local/is missing in your path. Just add it as explained.sascha
Please echo $PATH again after doing the above example.
|
I'm using OS X 10.10, open the shell, type
export PATH=$PATH:/usr/local/mysql/bin
it works temporary.if you use Command+T to open a new tab ,mysql command will not work anymore.
We need to create a .bash_profile file to make it work each time you open a new tab.
nano ~/.bash_profile
add the following line to the file.
# Set architecture flags
export ARCHFLAGS="-arch x86_64"
# Ensure user-installed binaries take precedence
export PATH=/usr/local/mysql/bin:$PATH
# Load .bashrc if it exists
test -f ~/.bashrc && source ~/.bashrc
Save the file, then open a new shell tab, it works like a charm..
by the way, why not try https://github.com/dbcli/mycli
pip install -U mycli
it's a tool way better than the mysqlcli.. A command line client for MySQL that can do auto-completion and syntax highlighting
3 Comments
Tomasz Mularczyk
it would be worth mentioning that path to
/mysql/bin folder may differ and it's best to see for yourself where it is on your computer. Then change above commands accordingly.
horcle_buzz
Nice tool! I am SICK of MySQL Workbench, and have issues getting
mysql working at the command line on my MacBook - this worked right off the bat. Love the auto-completion!
Abel Callejo
My
mysql command line tool on mac worked like a slacker. It only worked after I added export ARCHFLAGS="-arch x86_64" in the .bash_profile file.On OSX 10.11, you can sudo nano /etc/paths and add the path(s) you want here, one per line. Way simpler than figuring which of ~/.bashrc, /etc/profile, '~/.bash_profile` etc... you should add to. Besides, why export and append $PATH to itself when you can just go and modify PATH directly...?
Comments
On mac, open the terminal and type:
cd /usr/local/mysql/bin
then type:
./mysql -u root -p
It will ask you for the mysql root password. Enter your password and use mysql database in the terminal.
Comments
I've tried all the solutions from the answers but couldn't get mysql command to work from the terminal, always getting the message
bash: command not found
The solution is to change the .bash_profile, and add the mysql path to .bash_profile
To do so follow these steps: 1. Open a new Terminal window or make sure you are in the home directory 2. Open .bash_profile using
nano .bash_profile
3. Add the following command to add the mysql path
PATH="/usr/local/mysql/bin:${PATH}"
export PATH
4. Press Ctrl+X, then press y and press enter.
The following is how my .bash_profile looks like
Comments
adding this code to my .profile worked for me: :/usr/local/mysql/bin
Thanks.
P.S This .profile is located in your user/ path. Its a hidden file so you will have to get to it either by a command in Terminal or using an html editor.
Comments
Open terminal and run:
/usr/local/mysql/bin/mysql --user=root -p
Comments
I think this is the simpler approach:
- Install mySQL-Shell package from mySQL site
- Run mysqlsh (should be added to your path by default after install)
- Connect to your database server like so: MySQL JS > \connect --mysql [username]@[endpoint/server]:3306
- Switch to SQL Mode by typing "\sql" in your prompt
- The console should print out the following to let you know you are good to go:
Switching to SQL mode... commands end with ;.
