Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.
Sign up to join this community
I installed mysql with homebrew.
mysql --version
mysql Ver 8.0.11 for osx10.13 on x86_64 (Homebrew)
and
which mysql
/usr/local/bin/mysql
but when I try to use it after a pipe, I get the following error
unzip -p dump.sql.zip | mysql
zsh: command not found: mysql
Why is that and how can I fix it?
You have an extra character before mysql that looks like a space, but is not a space. You have to fix that before running the command. This problem occurs when you press the space bar while you are holding the Option key.
$ # Option + Space
$ unzip -p dump.sql.zip | mysql
zsh: command not found: mysql
$ # Regular Space
$ unzip -p dump.sql.zip | mysql
...
expected output
...
Another example:
$ # Option + Space
$ echo "hi" | less
-bash: less: command not found
$ # Regular Space
$ echo "hi" | less
hi
(END)
Another option is to eliminate the space after the pipe entirely:
$ echo "hi" |less
hi
(END)
Option+Space = \xc2\xa0 (UTF-8)
Space = Regular Space
|mysql solves the problem it might be better to get used to relasing shift/opt/whatever after typing the pipe and before typing the space character.
cmd1 | cmd2 is perfectly valid shell syntax. And yes, depending on keyboard settings and locale it does.
Notice the extra space given after the ":" in the first error message. This is because of using the "option space" character instead of a normal space. Your output is similar t the first of these two
[![Option Space before first missing command in pipe[1]](https://i.stack.imgur.com/BKvfq.png)
mysqltakes several arguments like user, password (where applicable), database, etc. You seem to be missing a number of those.mysqlarguments, as whenmysqlis recognized, it will report another error.found:andmysqlin the error message you still had shift/opt/whatever pressed from typing the pipe character when you pressed space.