MySQL from OSX Terminal

Question

I seem to be missing something as all of the tutorials that show how to run MySQL from OSX's command line aren't working.

I can turn the MySQL Server status on and off via System preferences, but if I follow one of the tutorial that shows how to run from the command line using sudo mysqld_safe it returns the sudo: mysqld: command not found

I've also tried logging into MySQL using mysql -u root -p and I get bash: mysql: command not found

/usr/local/mysql/bin/ does exist I just feel like something wasn't installed properly on the client side. Any help figuring out how to access mysql from the terminal would be very much appreciated. Thanks in advance.

Elyas 'Eloy' Hadizadeh Tasbiti · Accepted Answer · 2020-02-27 18:55:19Z

26

/usr/local/mysql/bin is not in the default $PATH. $PATH is the list of directories that are searched when you try to use an executable without specifying a complete path.

You either need to use the full path (/usr/local/mysql/bin/mysql_executable_here) or add it to your $PATH:

export PATH="$PATH:/usr/local/mysql/bin"

For macOS Mojave and earlier

You can add this line to a file called .profile in your home directory to execute it each time you create a new shell:

echo 'export PATH="$PATH:/usr/local/mysql/bin"' >> ~/.profile
source ~/.profile
mysql -u USERNAME -p

For macOS Catalina and later

Starting with macOS Catalina, Mac devices use zsh as the default login shell and interactive shell and you have to update .zprofile file in your home directory.

echo 'export PATH="$PATH:/usr/local/mysql/bin"' >> ~/.zprofile
source ~/.zprofile
mysql -u USERNAME -p

edited Feb 27, 2020 at 18:55

Elyas 'Eloy' Hadizadeh Tasbiti

3,6958 gold badges48 silver badges62 bronze badges

answered May 3, 2014 at 17:35

zneak

139k48 gold badges270 silver badges342 bronze badges

Sign up to request clarification or add additional context in comments.

14 Comments

dbconfession Over a year ago

i used `sudo ./bin/mysqld_safe and that turned it on the server. I still can;'t figure out how to log into the client though.

dbconfession Over a year ago

i got it. I had to use sudo ./bin/local/mysql -u root -p Is there an easier way to do this, or do I have to always put the directory in the sudo line?

zneak Over a year ago

Have you read my answer? :/ I feel that it should answer this exact question and I'm not sure how to phrase it if it's not enough.

dbconfession Over a year ago

sorry. I got ahead of myself. Using the export line worked, but won't this screw up anything other than running mysql commands? Do I have to undo this when I'm finished?

zneak Over a year ago

Yes @StuartKuredjian, create it if it doesn't exist. This is what the suggested command will do anyways.

|

Kidane · Accepted Answer · 2016-10-25 18:53:35Z

6

I had this kind of problem as well. I resolved the issues like:-

go to the directory cd /usr/local/mysql/bin/
put this command ./mysql -u root -p;
it will ask you password the root password you get at the time of installation. that way you will get your mysql connected to the database... hope that helps..

edited Oct 25, 2016 at 18:53

answered Oct 25, 2016 at 16:53

Kidane

1251 silver badge4 bronze badges

Comments

DocJ457 · Accepted Answer · 2017-04-08 20:52:32Z

0

unless I'm missing something here, I believe you can just install mump and also run MySQL workbench. and you won't have to deal with a lot of these issues.

answered Apr 8, 2017 at 20:52

DocJ457

8878 silver badges18 bronze badges

Collectives™ on Stack Overflow

MySQL from OSX Terminal

3 Answers 3

14 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

14 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related