mysql command not found in bash

Question

On my mac, if I type mysql --version in bash, the bash shows that command not found.

$ echo $PATH
/Users/merle/.nvm/versions/node/v11.10.0/bin:/usr/local/opt/mysql\@5.5/bin:/Users/merle/Downloads/mongodb-osx-x86_64-4.0.4/bin:/Applications/PostgreSQL\ 10/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Library/TeX/texbin:/opt/X11/bin:/Library/Frameworks/Mono.framework/Versions/Current/Commands

$ /usr/local/opt/mysql\@5.5/bin/mysql --version
/usr/local/opt/[email protected]/bin/mysql  Ver 14.14 Distrib 5.5.62, for osx10.14 (x86_64) using  EditLine wrapper

$ mysql --version
-bash: mysql: command not found

I add the mysql bin directory to my PATH variable in my .bashrc. I don't know what is going on.

What is the output of which mysql?

Eyal
– Eyal

2019-06-06 22:45:53 +00:00
Commented Jun 6, 2019 at 22:45 — Eyal
– Eyal, Commented Jun 6, 2019 at 22:45
There is no output.

Merle
– Merle

2019-06-06 22:46:26 +00:00
Commented Jun 6, 2019 at 22:46 — Merle
– Merle, Commented Jun 6, 2019 at 22:46
Maybe try to log out and log in?

Eyal
– Eyal

2019-06-06 22:47:15 +00:00
Commented Jun 6, 2019 at 22:47 — Eyal
– Eyal, Commented Jun 6, 2019 at 22:47
Tried, didn't work,

Merle
– Merle

2019-06-06 22:54:49 +00:00
Commented Jun 6, 2019 at 22:54 — Merle
– Merle, Commented Jun 6, 2019 at 22:54
How did you install mysql?

tink
– tink

2019-06-06 22:56:20 +00:00
Commented Jun 6, 2019 at 22:56 — tink
– tink, Commented Jun 6, 2019 at 22:56

Eyal · Accepted Answer · 2019-06-06 23:05:06Z

2

The issue is with the backslash (\) in the PATH env:

/usr/local/opt/mysql\@5.5/bin

After removing it:

/usr/local/opt/[email protected]/bin

answered Jun 6, 2019 at 23:05

Eyal

1,7193 gold badges27 silver badges50 bronze badges

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

7 Comments

Merle Over a year ago

If I am in /usr/local/opt/, and I type cd my+Tab, it becomes cd mysql\@5.5. Why would this happen?

Eyal Over a year ago

I guess it depends on the context. From what we see, when using a @ in bash you'd need to escape it (\@); when using it in an environment variable you don't.

jeremysprofile Over a year ago

@Merle, a \ would also appear in a folder name with spaces. The blackslash is needed on the command line to let Bash know it's one contiguous variable, but in the bashrc, it is not required because it knows to go until the delimiter :

Merle Over a year ago

@jeremysprofile but this folder [email protected] doesn't have spaces.

Benjamin W. Over a year ago

It depends on how it was assigned in .bashrc: if it's PATH="/mysql\@5.5/bin", the backslash will be preserved; if it's PATH=/mysql\@5.5/bin, it doesn't matter.

|

Syscall · Accepted Answer · 2022-01-16 14:24:41Z

0

You need to add mysql to your env. Based on what are you using (standard bash or zsh or other), you need to open the configuration file such as

~/.zshrc or ~/.bash_profile and add there the following

export PATH = "${PATH}/etc/local/mysql/bin"

Do not forget to do to apply the changes

source ~/.zshrc

edited Jan 16, 2022 at 14:24

Syscall

19.8k10 gold badges44 silver badges60 bronze badges

answered Jan 16, 2022 at 14:21

Inesa Toroyan

312 bronze badges

1 Comment

David Tonhofer Over a year ago

That should probably be export PATH = "${PATH}:/etc/local/mysql/bin" to extend the existing value of PATH with /etc/local/mysql/bin (is the MySQL binary really in /etc/local? The mind boggles!)

Collectives™ on Stack Overflow

mysql command not found in bash

2 Answers 2

7 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related