entityMap|blocks|key|82d5j|text|这就是你的$PATH的问题：/usr/local//usr/local/mysql/bin/private/var/mysql/private/var/mysql/bi..。$PATH是shell搜索命令文件的位置。要搜索的文件夹需要用冒号分隔。所以你想/usr/local/mysql/bin/在你的路径中，而不是在你的路径中搜索|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|o86p|/usr/local//usr/local/mysql/bin/private/var/mysql/private/var/mysql/bin，这可能并不存在。相反，你想要${PATH}:/usr/local/mysql/bin..。也是如此|6h0pv|export+PATH=${PATH}:/usr/local/mysql/bin..。如果您希望每次打开终端时都运行此命令，请将其放入文件中.bash_profile，它在终端打开时运行。^0|E|1Y|2F|5|3J|L|0|0|1Z|2E|S|0|0|14|1Y|D^^$0|$]|1|@$2|3|4|5|6|7|8|K|9|@$A|L|B|M|C|D]|$A|N|B|O|C|D]|$A|P|B|Q|C|D]]|E|@]|F|$]]|$2|G|4|H|6|7|8|R|9|@$A|S|B|T|C|D]|$A|U|B|V|C|D]]|E|@]|F|$]]|$2|I|4|J|6|7|8|W|9|@$A|X|B|Y|C|D]|$A|Z|B|10|C|D]]|E|@]|F|$]]]]

This is the problem with your $PATH: 

<code>/usr/local//usr/local/mysql/bin/private/var/mysql/private/var/mysql/bin</code>. 

<code>$PATH</code> is where the shell searches for command files. Folders to search in need to be separated with a colon. And so you want <code>/usr/local/mysql/bin/</code> in your path but instead it searches in <code>/usr/local//usr/local/mysql/bin/private/var/mysql/private/var/mysql/bin</code>, which probably doesn't exist. 

Instead you want <code>${PATH}:/usr/local/mysql/bin</code>. 

So do <code>export PATH=${PATH}:/usr/local/mysql/bin</code>. 

If you want this to be run every time you open terminal put it in the file <code>.bash_profile</code>, which is run when Terminal opens.

entityMap|blocks|key|bnleq|text|另一种方法是在中创建软链接|type|unstyled|depth|inlineStyleRanges|entityRanges|data|b999o|/usr/local/binln+-s+/usr/local/mysql/bin/mysql+/usr/local/bin/mysql|code-block|syntax|js|c5ncc|但如果您需要其他可执行文件，如mysqldump，您将需要为它们创建软链接。|offset|length|style|CODE^0|0|0|F|9^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|O|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|P|9|@$J|Q|K|R|L|M]]|A|@]|B|$]]]]

One alternative way is creating soft link in <code>/usr/local/bin</code>

<pre><code>ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql
</code></pre>

But if you need other executables like <code>mysqldump</code>, you will need to create soft link for them.

entityMap|blocks|key|1l62k|text|我也面临着同样的问题，最终我得到了一个解决方案。如果您使用的是MAMP，请执行以下步骤。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|a4k4l|启动MAMP或MAMP+PRO|ordered-list-item|cvriu|启动服务器|2rimg|打开终端(应用程序->实用程序)|cfsks|键入：(一行) /Applications/MAMP/Library/bin/mysql+--host=localhost+-uroot+-proot|1h8tj|这对我很有效。^0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|O|9|@]|A|@]|B|$]]|$2|F|4|G|6|E|8|P|9|@]|A|@]|B|$]]|$2|H|4|I|6|E|8|Q|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|R|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|S|9|@]|A|@]|B|$]]]]

I faced the same issue, and finally i got a solution. Please go through with the below steps, if you are using MAMP.

<ol>
<li>Start MAMP or MAMP PRO</li>
<li>Start the server</li>
<li>Open Terminal (Applications -> Utilities)</li>
<li>Type in: (one line)
  /Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot</li>
</ol>

This works for me.

entityMap|blocks|key|cjgh8|text|您必须在您的.bashrc使用以下命令创建文件：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|6de1r|export+PATH=$PATH:/usr/local/mysql/bin|code-block|syntax|js|7tr5n|但是如果您正在使用oh+my+zsh然后你必须在里面添加路径.zshrc文件。^0|6|7|0|0|9|9|U|6^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@$A|O|B|P|C|D]]|E|@]|F|$]]|$2|G|4|H|6|I|8|Q|9|@]|E|@]|F|$J|K]]|$2|L|4|M|6|7|8|R|9|@$A|S|B|T|C|D]|$A|U|B|V|C|D]]|E|@]|F|$]]]]

You have to set PATH for mysql in your <code>.bashrc</code> file using following:

<pre><code> export PATH=$PATH:/usr/local/mysql/bin
</code></pre>

But If you are using <code>oh my zsh</code> then you have to add path inside <code>.zshrc</code> file.

entityMap|blocks|key|9d4j8|text|你的路径可能无法设置。转到终端并键入：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|eeegg|echo+'export+PATH="/usr/local/mysql/bin:$PATH"'+>>+~/.bash_profile|CODE|4b57o|本质上，这允许您从任何地方访问mysql。|293sf|类型cat+.bash_profile检查路径是否已设置。|fqulp|检查mysql当前版本：mysql+--version|c5noa|如果仍然不起作用，请关闭终端并重新打开。现在检查版本，它应该可以工作。祝你好运！^0|2|2|0|0|1U|0|0|2|H|0|2|5|C|F|0^^$0|$]|1|@$2|3|4|5|6|7|8|R|9|@$A|S|B|T|C|D]]|E|@]|F|$]]|$2|G|4|H|6|7|8|U|9|@$A|V|B|W|C|I]]|E|@]|F|$]]|$2|J|4|K|6|7|8|X|9|@]|E|@]|F|$]]|$2|L|4|M|6|7|8|Y|9|@$A|Z|B|10|C|I]]|E|@]|F|$]]|$2|N|4|O|6|7|8|11|9|@$A|12|B|13|C|D]|$A|14|B|15|C|I]]|E|@]|F|$]]|$2|P|4|Q|6|7|8|16|9|@]|E|@]|F|$]]]]

Your PATH might not setup. Go to terminal and type:

<code>echo 'export PATH="/usr/local/mysql/bin:$PATH"' &gt;&gt; ~/.bash_profile</code>

Essentially, this allows you to access mysql from anywhere.

Type <code>cat .bash_profile</code> to check the PATH has been setup.

Check mysql version now: <code>mysql --version</code>

If this still doesn't work, close the terminal and reopen. Check the version now, it should work. Good luck!

entityMap|blocks|key|4a3l|text|我已经尝试了很多关于SO的建议，但这是一个对我有效的建议：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3epie|sudo+sh+-c+'echo+/usr/local/mysql/bin+>+/etc/paths.d/mysql'|code-block|syntax|js|8jaka|然后你输入|8pbb8|mysql|8dodq|它将提示您输入密码。^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|O|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|P|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|Q|9|@]|A|@]|B|$F|G]]|$2|L|4|M|6|7|8|R|9|@]|A|@]|B|$]]]]

I have tried a lot of the suggestions on SO but this is the one that actually worked for me:

<pre><code>sudo sh -c 'echo /usr/local/mysql/bin &gt; /etc/paths.d/mysql'
</code></pre>

then you type 

<pre><code>mysql
</code></pre>

It will prompt you to enter your password.

entityMap|blocks|key|ev61i|text|如果您使用的是终端，则需要将以下内容添加到./bash_profile|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|d0lo3|export+PATH="/usr/local/mysql/bin:$PATH"|ambo4|如果您使用的是zsh，则需要将以上行添加到您的~/.zshrc^0|L|E|0|0|14|0|N|8^^$0|$]|1|@$2|3|4|5|6|7|8|K|9|@$A|L|B|M|C|D]]|E|@]|F|$]]|$2|G|4|H|6|7|8|N|9|@$A|O|B|P|C|D]]|E|@]|F|$]]|$2|I|4|J|6|7|8|Q|9|@$A|R|B|S|C|D]]|E|@]|F|$]]]]

If you are using terminal you will want to add the following to <code>./bash_profile</code>

<code>export PATH="/usr/local/mysql/bin:$PATH"</code>

If you are using zsh, you will want to add the above line to your <code>~/.zshrc</code>

entityMap|blocks|key|d1b3o|text|在bash中添加以下行_配置文件：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|eq749|alias+startmysql='sudo+/usr/local/mysql/support-files/mysql.server+start'
alias+stopmysql='sudo+/usr/local/mysql/support-files/mysql.server+stop'|code-block|syntax|javascript|12sqh|并保存bash_配置文件。|au9ar|现在，在终端中使用以下命令启动和停止mysql服务器：|49f1k|startmysql+//to+start+mysql+server|js|88s8d|和|4iup4|stopmysql+//to+stop+mysql+server^0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|S|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|T|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|U|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|V|9|@]|A|@]|B|$]]|$2|L|4|M|6|E|8|W|9|@]|A|@]|B|$F|N]]|$2|O|4|P|6|7|8|X|9|@]|A|@]|B|$]]|$2|Q|4|R|6|E|8|Y|9|@]|A|@]|B|$F|N]]]]

Add the following lines in bash_profile:

<pre><code>alias startmysql='sudo /usr/local/mysql/support-files/mysql.server start'
alias stopmysql='sudo /usr/local/mysql/support-files/mysql.server stop'
</code></pre>

and save the bash_profile.

Now, in the terminal start and stop the mysql server using the following commands:

<pre><code>startmysql //to start mysql server
</code></pre>

and

<pre><code>stopmysql //to stop mysql server
</code></pre>

entityMap|blocks|key|9i9hp|text|我安装了MAMP，phpmyadmin正在工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|fdjbq|但找不到/usr/local/bin/mysql|8qd6m|这解决了它|dua19|sudo+ln+-s+/Applications/MAMP/Library/bin/mysql+/usr/local/bin/mysql|code-block|syntax|js^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|M|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|N|9|@]|A|@]|B|$]]|$2|G|4|H|6|I|8|O|9|@]|A|@]|B|$J|K]]]]

I installed MAMP and phpmyadmin was working. 

But cannot find /usr/local/bin/mysql

This fixed it 

<pre><code>sudo ln -s /Applications/MAMP/Library/bin/mysql /usr/local/bin/mysql
</code></pre>

entityMap|blocks|key|8v6ks|text|在终端do中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3hms7|vi+~/.bash_profile|code-block|syntax|js|4e8cd|然后添加这一行：|aqclr|export+PATH=${PATH}:/usr/local/mysql/bin|fn87d|并在终端中键入以下内容：|3uide|mysql+-u+[username]+-p+[password]^0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|P|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|Q|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|R|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|S|9|@]|A|@]|B|$F|G]]|$2|L|4|M|6|7|8|T|9|@]|A|@]|B|$]]|$2|N|4|O|6|E|8|U|9|@]|A|@]|B|$F|G]]]]

in terminal do: 

<pre><code>vi ~/.bash_profile 
</code></pre>

And add this line: 

<pre><code>export PATH=${PATH}:/usr/local/mysql/bin
</code></pre>

and the type this in terminal: 

<pre><code>mysql -u [username] -p [password]
</code></pre>

entityMap|blocks|key|3son4|text|也许我会帮助别人。上面的答案对Catalina都不起作用。最后，这解决了问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|20m6n|echo+'export+PATH="/usr/local/opt/mysql@5.7/bin:$PATH"'+>>+/Users/$(whoami)/.bash_profile|offset|length|style|CODE|d8tvt|当然，您必须更改已安装的mysql的版本^0|0|0|2H|0^^$0|$]|1|@$2|3|4|5|6|7|8|K|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|L|9|@$E|M|F|N|G|H]]|A|@]|B|$]]|$2|I|4|J|6|7|8|O|9|@]|A|@]|B|$]]]]

Maybe I'll help someone else. None of the above answers worked for Catalina. Finally, this solved the problem

<code>echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' &gt;&gt; /Users/$(whoami)/.bash_profile</code>

Of course, you have to change for the version of mysql you have installed

entityMap|blocks|key|cgmou|text|使用MAMP|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4o59b|mysql通常位于/Applications/MAMP/Library/bin/mysql|ordered-list-item|syntax|js|29dse|sudo+vi+/etc/path|5fsv0|将此路径添加到文件/Applications/MAMP/Library/bin|51hi8|:wq+(保存并退出文件)|6rnf8|关闭终端窗口|6i5mu|重新打开终端并输入mysql，它应该可以工作^0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|R|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|S|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|E|8|T|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|U|9|@]|A|@]|B|$]]|$2|L|4|M|6|E|8|V|9|@]|A|@]|B|$]]|$2|N|4|O|6|E|8|W|9|@]|A|@]|B|$]]|$2|P|4|Q|6|E|8|X|9|@]|A|@]|B|$]]]]

With MAMP

<ol>
<li>Locate mysql usually at /Applications/MAMP/Library/bin/mysql</li>
<li>sudo vi /etc/paths</li>
<li>Add this path to file /Applications/MAMP/Library/bin</li>
<li>:wq (Save and quit file)</li>
<li>Close Terminal windows</li>
<li>Reopen Terminal and type mysql and it should work</li>
</ol>

entityMap|blocks|key|dsn2d|text|也许我会帮助你们中的一些人，即使你们在尝试在.bash中更改路径后无法从终端打开mysql_配置文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8mrhn|然后你总是发现错误"MYSQL+not+found“，因此你可以直接使用下面的命令，它会要求你输入密码，sql+bash就会被打开|3r2pp|/usr/local/mysql/bin/mysql+-u根-p^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|G|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|H|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|I|9|@]|A|@]|B|$]]]]

May be i will help out some of you that even though if you are unable to open mysql from terminal after trying changing path in .bash_profile
then you always found the error &quot;MYSQL not found&quot;
hence you can use the following command directly it will ask for your password and sql bash is opened
/usr/local/mysql/bin/mysql -u root -p

entityMap|blocks|key|24g70|text|我在安装后也遇到了同样的问题mariadb通过HomeBrewbrew+doctor|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|94drq|建议运行brew+link+mariadb-修复了该问题。^0|E|7|N|8|V|B|0|4|H^^$0|$]|1|@$2|3|4|5|6|7|8|J|9|@$A|K|B|L|C|D]|$A|M|B|N|C|D]|$A|O|B|P|C|E]]|F|@]|G|$]]|$2|H|4|I|6|7|8|Q|9|@$A|R|B|S|C|E]]|F|@]|G|$]]]]

I had same issue after installing mariadb via HomeBrew, <code>brew doctor</code> suggested to run <code>brew link mariadb</code> - which fixed the issue.

entityMap|blocks|key|eb1vf|text|在终端中使用以下两个命令|type|unstyled|depth|inlineStyleRanges|entityRanges|data|j1uq|alias+mysql=/usr/local/mysql/bin/mysql
mysql+--user=root+-p|code-block|syntax|javascript|3m8kj|然后，它将要求您输入您的用户pc的密码|2mf2n|输入密码：^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|M|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|N|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|O|9|@]|A|@]|B|$]]]]

Use these two commands in your terminal
<pre><code>alias mysql=/usr/local/mysql/bin/mysql
mysql --user=root -p
</code></pre>
Then it will ask you to enter password of your user pc
Enter password:

entityMap|blocks|key|f093d|text|如果您使用的是zsh而不是.bash，那么您必须在.zshenv中而不是在bash中输入上述命令_配置文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

It is possible you are using zsh instead of bash then you have to enter the above mentioned commands in .zshenv instead of .bash_profile

I cant get my mysql to start on os x 10.7. It is located in <code>/usr/local/mysql/bin/mysql</code>

I get command not found when I type <code>mysql --version</code> in the terminal.

I tried this <a href="https://stackoverflow.com/questions/8195418/cant-access-mysql-from-command-line-mac">can&#39;t access mysql from command line mac</a> but still get command not found. I tried installing mysql with the dmg and i have tried to install it through homebrew and I cant get it to work. When I try to start mysql with homebrew I get <a href="https://stackoverflow.com/questions/10576743/mysql-wont-start/10576831#10576831">MySQL won&#39;t start</a>

This is my <code>$PATH</code>:

<blockquote>
 /usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin:/usr/local/git/bin:/Users/Victoria/bin:/usr/local//usr/local/mysql/bin/private/var/mysql/private/var/mysql/bin
</blockquote>

Mysql command not found in OS X 10.7

服务器

MySQL

 我无法让我的mysql在os x 10.7上启动。它位于/usr/local/mysql/bin/mysql 当我键入以下命令时，我收到命令未找到mysql --version 在终端。 我试过这无法从命令行 mac 访问 mysql但仍未找到get命令。我试着用dmg安装mysql，我试着通过homebrew安装它，但是我不能让它工作。当我尝试使用自制软件启动 mysql 时，我发现 MySQ

问在OS X 10.7中找不到Mysql命令
EN

回答 16

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在OS X 10.7中找不到Mysql命令EN

回答 16

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在OS X 10.7中找不到Mysql命令
EN