Mysql command not found in OS X 10 7

Question

I cant get my mysql to start  on os x 10 7   It is located in  usr local mysql bin mysql  I get command not found when I type mysql --version in the terminal   I tried this can  39 t access mysql from command line mac but still get command not found   I tried installing mysql with the dmg and i have tried to install it through homebrew and I cant get it to work   When I try to start mysql with homebrew I get MySQL won  39 t start  This is my  PATH       usr bin  bin  usr sbin  sbin  usr local bin  usr X11 bin  usr local git bin  Users Victoria bin  usr local  usr local mysql bin private var mysql private var mysql bin

User · Answer

If you installed MySQL Server and you still get

mysql -u root -p command not found

You're most likely experiencing this because you have an older mac version.

Try this:

in the home directory in terminal open -t .bash_profile

paste export PATH=${PATH}:/usr/local/mysql/bin/ inside and save it

instead of writing mysql -u root -p paste the following in your terminal:

/usr/local/mysql/bin/mysql -u root -p

Enter your password. Now you're in.

User · Answer

Your PATH might not setup  Go to terminal and type   echo  export PATH   usr local mysql bin  PATH    gt  gt     bash profile  Essentially  this allows you to access mysql from anywhere   Type cat  bash profile to check the PATH has been setup   Check mysql version now  mysql --version  If this still doesn t work  close the terminal and reopen  Check the version now  it should work  Good luck

User · Answer

May be i will help out some of you that  even though if you are unable to open mysql from terminal after trying changing path in  bash profile then you always found the error  quot MYSQL not found quot  hence you can use the following command directly it will ask for your password and sql bash is opened  usr local mysql bin mysql -u root -p

User · Answer

With MAMP   Locate mysql usually at  Applications MAMP Library bin mysql sudo vi  etc paths Add this path to file  Applications MAMP Library bin  wq  Save and quit file  Close Terminal windows Reopen Terminal and type mysql and it should work

User · Answer

Use these two commands in your terminal alias mysql  usr local mysql bin mysql mysql --user root -p  Then it will ask you to enter password of your user pc Enter password

User · Answer

I installed MAMP and phpmyadmin was working    But cannot find  usr local bin mysql  This fixed it   sudo ln -s  Applications MAMP Library bin mysql  usr local bin mysql

User · Answer

I faced the same issue  and finally i got a solution  Please go through with the below steps  if you are using MAMP    Start MAMP or MAMP PRO Start the server Open Terminal  Applications -  Utilities  Type in   one line       Applications MAMP Library bin mysql --host localhost -uroot -proot   This works for me

User · Answer

in terminal do    vi    bash profile    And add this line    export PATH   PATH   usr local mysql bin   and the type this in terminal    mysql -u  username  -p  password

User · Answer

You have to set PATH for mysql in your  bashrc file using following     export PATH  PATH  usr local mysql bin   But If you are using oh my zsh then you have to add path inside  zshrc file

User · Answer

It is possible you are using zsh instead of bash then you have to enter the above mentioned commands in  zshenv instead of  bash profile

User · Answer

I had same issue after installing mariadb via HomeBrew  brew doctor suggested to run brew link mariadb - which fixed the issue

User · Answer

One alternative way is creating soft link in  usr local bin  ln -s  usr local mysql bin mysql  usr local bin mysql   But if you need other executables like mysqldump  you will need to create soft link for them

User · Answer

I have tried a lot of the suggestions on SO but this is the one that actually worked for me   sudo sh -c  echo  usr local mysql bin  gt   etc paths d mysql    then you type   mysql   It will prompt you to enter your password

User · Answer

Add the following lines in bash profile   alias startmysql  sudo  usr local mysql support-files mysql server start  alias stopmysql  sudo  usr local mysql support-files mysql server stop    and save the bash profile   Now  in the terminal start and stop the mysql server using the following commands   startmysql   to start mysql server   and  stopmysql   to stop mysql server

User · Answer

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

User · Answer

If you are using terminal you will want to add the following to   bash profile  export PATH   usr local mysql bin  PATH   If you are using zsh  you will want to add the above line to your    zshrc

User · Answer

Maybe I ll help someone else  None of the above answers worked for Catalina  Finally  this solved the problem  echo  export PATH   usr local opt mysql 5 7 bin  PATH    gt  gt   Users   whoami   bash profile  Of course  you have to change for the version of mysql you have installed

[mysql] Mysql command not found in OS X 10.7

Examples related to mysql