Using Mysql in the command line in osx - command not found

Question

I m trying to get mysql up and running on my mac osx 10 9 5   I ve installed the latest version14 14 5 6 21 community server   I ve gone to system preferences and started the mysql server  then launched terminal and typed this    usr local mysql bin mysql --version which returns the version  but when I type any type of mysql command I get command not found   I ve also tried sudo mysql secure installation  mysql -u root --password password   I do have web hosting with mysql etc installed  but I want to be able to get to grips with it in the command line first

User · Answer

You can just modified the  bash profile by adding the MySQL  PATH as the following  export PATH  PATH  usr local mysql bin   I did the following   1- Open Terminal then   nano  bash profile or   vim  bash profile   2- Add the following PATH code to the  bash profile    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  amp  amp  source    bashrc    3- Save the file   4- Refresh Terminal using   source    bash profile  5- To verify  type in Terminal   mysql --version   6- It should print the output something like this      mysql  Ver 14 14 Distrib 5 7 17  for macos10 12  x86 64    The Terminal is now configured to read the MySQL commands from  PATH which is placed in the  bash profile

User · Answer

You have to create a symlink to your mysql installation if it is not the most recent version of mysql     brew link --force mysql 5 6   see this post by Alex Todd

User · Answer

modify your bash profile as follows   lt   vim    bash profile  export PATH  usr local mysql bin  PATH Once its saved you can type in mysql to bring mysql prompt in your terminal

User · Answer

for me the following commands worked     brew install mysql    brew services start mysql

User · Answer

So there are few places where terminal looks for commands  This places are stored in your  PATH variable  Think of it as a global variable where terminal iterates over to look up for any command  This are usually binaries look how  bin folder is usually referenced     bin folder has lots of executable files inside it  Turns out this are command  This different folder locations are stored inside one Global variable i e   PATH separated by    Now usually programs upon installation takes care of updating PATH  amp  telling your terminal that hey i can be all commands inside my bin folder    Turns out MySql doesn t do it upon install so we manually have to do it    We do it by following command    export PATH  PATH  usr local mysql bin   If you break it down  export is self explanatory  Think of it as an assignment  So export a variable PATH with value old  PATH concat with new bin i e   usr local mysql bin  This way after executing it all the commands inside  usr local mysql bin are available to us    There is a small catch here  Think of one terminal window as one instance of program and maybe something like  PATH is class variable   maybe    Note this is pure assumption  So upon close we lose the new assignment  And if we reopen terminal we won t have access to our command again because last when we exported  it was stored in primary memory which is volatile    Now we need to have our mysql binaries exported every-time we use terminal  So we have to persist concat in our path    You might be aware that our terminal using something called dotfiles to load configuration on terminal initialisation  I like to think of it s as sets of thing passed to constructer every-time a new instance of terminal is created   Again an assumption but close to what it might be doing     So yes by now you get the point what we are going todo     bash profile is one of the primary known dotfile    So in following command    echo  export PATH  PATH  usr local mysql bin   gt  gt     bash profile   What we are doing is saving result of echo i e  output string to    bash profile  So now as we noted above every-time we open terminal or instance of terminal our dotfiles are loaded  So  bash profile is loaded respectively and export that we appended above is run  amp  thus a our global  PATH gets updated and we get all the commands inside  usr local mysql bin    P s    if you are not running first command export directly but just running second in order to persist it  Than for current running instance of terminal you have to   source    bash profile   This tells our terminal to reload that particular file

User · Answer

That means  usr local mysql bin mysql is not in the PATH variable      Either execute  usr local mysql bin mysql to get your mysql shell   or type this in your terminal   PATH  PATH  usr local mysql bin   to add that to your PATH variable so you can just run mysql without specifying the path

[mysql] Using Mysql in the command line in osx - command not found?

Examples related to mysql

Examples related to macos