MYSQL terminal Mac command not working 'mysql'

Question

I have a hidden file in my home directory called .profile with the following:

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

The following command works:

$ /usr/local/mysql/bin/mysql

However mysql does not. How can I change the path to make the command work? I have MAMP installed, I'm just not sure how to use it. Thanks!

Ankit Sharma · Accepted Answer · 2012-04-19 08:31:38Z

8

I believe the error is in your first line:

   MYSQL_HOME=/usr/local/mysql/bin/mysql

Which should be like this:

  MYSQL_HOME=/usr/local/mysql

edited Apr 19, 2012 at 8:31

Ankit Sharma

4,0792 gold badges31 silver badges50 bronze badges

answered Apr 19, 2012 at 2:11

Felix Fung

1,75719 silver badges27 bronze badges

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

3 Comments

Michael Berkowski Over a year ago

And remove the spaces around the =

KBouldin9 Over a year ago

MYSQL_HOME=/usr/local/mysql/ export PATH=$MYSQL_HOME/bin:$PATH Still doesn't work when i call echo $PATH it gives me: /bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin

Olaf Over a year ago

after editing the .profile exit the shell and re-enter. Alternatively do . <space> ~/.profile to source the changed path

Collectives™ on Stack Overflow

MYSQL terminal Mac command not working 'mysql'

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related