blocks|key|1539116|text|根据您是使用官方的二进制安装程序、使用MacPorts还是使用Homebrew来安装MySQL，有不同的情况|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1539117|自制软件|1539118|brew+services+start+mysql
brew+services+stop+mysql
brew+services+restart+mysql|code-block|syntax|javascript|1539119|MacPorts|1539120|sudo+port+load+mysql57-server
sudo+port+unload+mysql57-server|1539121|注意:这在重新启动后是持久的。|1539122|二进制安装程序|1539123|sudo+/Library/StartupItems/MySQLCOM/MySQLCOM+stop
sudo+/Library/StartupItems/MySQLCOM/MySQLCOM+start
sudo+/Library/StartupItems/MySQLCOM/MySQLCOM+restart|1539124|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/MacPorts|1|http://brew.sh/|2|http://en.wikipedia.org/wiki/MySQL^0|J|8|0|V|8|1|16|5|2|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@$A|17|B|18|1|19]|$A|1A|B|1B|1|1C]|$A|1D|B|1E|1|1F]]|C|$]]|$1|D|3|E|5|6|7|1G|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|1H|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|1I|8|@]|9|@]|C|$]]|$1|M|3|N|5|H|7|1J|8|@]|9|@]|C|$I|J]]|$1|O|3|P|5|6|7|1K|8|@]|9|@]|C|$]]|$1|Q|3|R|5|6|7|1L|8|@]|9|@]|C|$]]|$1|S|3|T|5|H|7|1M|8|@]|9|@]|C|$I|J]]|$1|U|3|-4|5|6|7|1N|8|@]|9|@]|C|$]]]|V|$W|$5|X|Y|Z|C|$10|11]]|12|$5|X|Y|Z|C|$10|13]]|14|$5|X|Y|Z|C|$10|15]]]]

There are different cases depending on whether you installed <a href="http://en.wikipedia.org/wiki/MySQL" rel="noreferrer">MySQL</a> with the official binary installer, using <a href="http://en.wikipedia.org/wiki/MacPorts" rel="noreferrer">MacPorts</a>, or using <a href="http://brew.sh/" rel="noreferrer">Homebrew</a>:

<h2>Homebrew</h2>

<pre><code>brew services start mysql
brew services stop mysql
brew services restart mysql
</code></pre>

<h2>MacPorts</h2>

<pre><code>sudo port load mysql57-server
sudo port unload mysql57-server
</code></pre>

Note: this is persistent after a reboot.

<h2>Binary installer</h2>

<pre><code>sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart
</code></pre>

blocks|key|1538963|text|你可以随时使用命令"mysqladmin+shutdown“|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1538964|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can always use command "mysqladmin shutdown"

blocks|key|1754433|text|如果您使用的是homebrew，则可以使用|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1754434|brew+services+restart+mysql
brew+services+start+mysql
brew+services+stop+mysql|code-block|syntax|javascript|1754435|获取可用服务的列表|1754436|brew+services+list|1754437|entityMap^0|7|8|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

If you are using <code>homebrew</code> you can use

<pre><code>brew services restart mysql
brew services start mysql
brew services stop mysql
</code></pre>

for a list of available services 

<pre><code>brew services list
</code></pre>

blocks|key|1539326|text|sudo+/usr/local/mysql/support-files/mysql.server停止|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1539327|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

sudo /usr/local/mysql/support-files/mysql.server stop

blocks|key|1753985|text|sudo+/opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper+stop|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1753986|您还可以在此处使用start和restart。我通过查看/Library/LaunchDaemons/org.macports.mysql.plist.的内容发现了这一点|1753987|entityMap^0|0|21|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

<code>sudo /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop</code>

You can also use start and restart here. I found this by looking at the contents of /Library/LaunchDaemons/org.macports.mysql.plist.

blocks|key|1539255|text|试一试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1539256|sudo+<path+to+mysql>/support-files/mysql.server+start
sudo+<path+to+mysql>/support-files/mysql.server+stop|code-block|syntax|javascript|1539257|否则，请尝试：|1539258|sudo+/Library/StartupItems/MySQLCOM/MySQLCOM+start
sudo+/Library/StartupItems/MySQLCOM/MySQLCOM+stop 
sudo+/Library/StartupItems/MySQLCOM/MySQLCOM+restart|1539259|但是，我发现第二个选项(OS+X+10.6，MySQL+5.1.50)只有在.plist加载了以下选项时才起作用：|1539260|sudo+launchctl+load+-w+/Library/LaunchDaemons/com.mysql.mysqld.plist|1539261|PS:我还发现我需要卸载.plist才能正确启动/停止与MAMP-MySQL无关的安装。运行此命令后，MAMP-MySQL启动正常：|offset|length|1539262|sudo启动sudo+unload+-w+/Library/LaunchDaemons/com.mysql.mysqld.plist|1539263|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/MAMP^0|0|0|0|0|0|0|S|4|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|16|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|18|8|@]|9|@$Q|19|R|1A|1|1B]]|A|$]]|$1|S|3|T|5|6|7|1C|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]]]

Try 

<pre><code>sudo &lt;path to mysql&gt;/support-files/mysql.server start
sudo &lt;path to mysql&gt;/support-files/mysql.server stop
</code></pre>

Else try:

<pre><code>sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop&lt;br&gt;
sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart
</code></pre>

However, I found that the second option only worked (OS X 10.6, MySQL 5.1.50) if the .plist has been loaded with:

<pre><code>sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysqld.plist
</code></pre>

PS: I also found that I needed to unload the .plist to get an unrelated install of <a href="http://en.wikipedia.org/wiki/MAMP" rel="noreferrer">MAMP</a>-MySQL to start / stop correctly. After running running this, MAMP-MySQL starts just fine:

sudo launchctl unload -w /Library/LaunchDaemons/com.mysql.mysqld.plist

blocks|key|1539765|text|在我的例子中，当我使用PID终止进程时，它一直在重启。此外，brew+stop命令不起作用，因为我没有使用自制软件安装。然后我转到mac系统偏好设置，我们在那里安装了MySQL。只需打开它并停止MySQL服务器，就完成了。在屏幕截图中，您可以在系统首选项的底部找到MySQL。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1539766|📷|atomic|1539767|​|1539768|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/1121da7f7d4f9a772ecb97b7d9bd4356.png|imageAlt^0|U|9|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|W|8|@]|D|@$9|X|A|Y|1|Z]]|E|$]]|$1|I|3|J|5|6|7|10|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R|S|-4]]]]

In my case, it kept on restarting as soon as I killed the process using PID. Also <code>brew stop</code> command didn't work as I installed without using homebrew. Then I went to mac system preferences and we have MySQL installed there. Just open it and stop the MySQL server and you're done. Here in the screenshot, you can find MySQL in bottom of system preferences. <a href="https://i.stack.imgur.com/NqLCN.png" rel="noreferrer"><img src="https://i.stack.imgur.com/NqLCN.png" alt="enter image description here"></a>

blocks|key|1754378|text|在我的mac+osx+yosemite+10.10上。此命令起作用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1754379|sudo+launchctl+load+-w+/Library/LaunchDaemons/com.mysql.mysql.plist
sudo+launchctl+unload+-w+/Library/LaunchDaemons/com.mysql.mysql.plist|code-block|syntax|javascript|1754380|您可以在文件夹/Library/LaunchDaemons/中找到要运行的mysql文件|1754381|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

On my mac osx yosemite 10.10. This command worked:

<pre><code>sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysql.plist
sudo launchctl unload -w /Library/LaunchDaemons/com.mysql.mysql.plist
</code></pre>

You can find your mysql file in folder /Library/LaunchDaemons/ to run

blocks|key|1539615|text|最新的OSX+(10.8)和MySQL5.6，该文件位于Launch+Daemons下，并且是com.oracle.oss.mysql.mysqld.plist。它在“系统选项”下显示一个选项，通常位于列表的底部。因此，转到系统设置，单击Mysql，并在选项框中将其关闭。https://dev.mysql.com/doc/refman/5.6/en/osx-installation-launchd.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1539616|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.6/en/osx-installation-launchd.html^0|3S|1X|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Latest OSX (10.8) and mysql 5.6, the file is under Launch Daemons and is com.oracle.oss.mysql.mysqld.plist. It presents an option under System Options, usually the bottom of the list. So go to system settings, click on Mysql, and turn it off from the option box. <a href="https://dev.mysql.com/doc/refman/5.6/en/osx-installation-launchd.html" rel="noreferrer">https://dev.mysql.com/doc/refman/5.6/en/osx-installation-launchd.html</a>

blocks|key|1539066|text|好吧，如果所有其他方法都失败了，您可以采取无情的方法，手动杀死运行MySQL的进程。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1539067|那是,|1539068|ps+-Af|code-block|syntax|javascript|1539069|要列出所有进程，请执行"kill+<pid>“，其中<pid>是MySQL守护进程(mysqld)的进程id。|offset|length|style|CODE|1539070|entityMap^0|0|0|0|C|A|Q|5|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@$K|U|L|V|M|N]|$K|W|L|X|M|N]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

Well, if all else fails, you could just take the ruthless approach and kill the process running MySQL manually.

That is,

<pre><code>ps -Af
</code></pre>

to list all processes, then do "<code>kill &lt;pid&gt;</code>" where <code>&lt;pid&gt;</code> is the process id of the MySQL daemon (mysqld).

blocks|key|1539312|text|对我来说，它与"mysql5“一起工作|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1539313|sudo+launchctl+unload+-w+/Library/LaunchDaemons/org.macports.mysql5.plist
sudo+launchctl+load+-w+/Library/LaunchDaemons/org.macports.mysql5.plist|code-block|syntax|javascript|1539314|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For me it's working with a "mysql5"

<pre><code>sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist
sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
</code></pre>

blocks|key|1539888|text|对我来说，以下解决方案适用于Unable+to+stop+MySQL+on+OS+X+10.10|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1539889|要停止我使用的自动启动：|1539890|sudo+launchctl+unload+-w+/Library/LaunchDaemons/com.mysql.mysql.plist|code-block|syntax|javascript|1539891|并终止我使用的服务：|1539892|sudo+pkill+mysqld|1539893|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/29375253/unable-to-stop-mysql-on-os-x-10-10^0|E|Y|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|C|$]]|$1|M|3|N|5|H|7|13|8|@]|9|@]|C|$I|J]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

For me the following solution worked <a href="https://stackoverflow.com/questions/29375253/unable-to-stop-mysql-on-os-x-10-10">Unable to stop MySQL on OS X 10.10</a>
To stop the auto start I used:
<pre><code>sudo launchctl unload -w /Library/LaunchDaemons/com.mysql.mysql.plist
</code></pre>
And to kill the service I used:
<pre><code>sudo pkill mysqld
</code></pre>

blocks|key|1539936|text|获取实例名称：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1539937|ls+/Library/LaunchDaemons+%7C+grep+mysql|code-block|syntax|javascript|1539938|停止MySQL实例(适用于MacOS+Catalina、MySQL+8)：|1539939|sudo+launchctl+unload+/Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist|1539940|或者，您可以在中停止MySQL实例|1539941|MacOS+Settings+>+MySQL+>+Stop+MySQL+Server+|1539942|此外，请在此处查看更多方法：https://tableplus.com/blog/2018/10/how-to-start-stop-restart-mysql-server.html|offset|length|1539943|entityMap|0|LINK|mutability|MUTABLE|url|https://tableplus.com/blog/2018/10/how-to-start-stop-restart-mysql-server.html^0|0|0|0|0|0|0|E|26|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|16|8|@]|9|@$Q|17|R|18|1|19]]|A|$]]|$1|S|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

Get instance name:
<pre><code>ls /Library/LaunchDaemons | grep mysql
</code></pre>
Stop MySQL instance (Works on MacOS Catalina, MySQL 8):
<pre><code>sudo launchctl unload /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
</code></pre>
Or, you can Stop MySQL instance in
<pre><code>MacOS Settings &gt; MySQL &gt; Stop MySQL Server 
</code></pre>
Also, check here for more methods:
<a href="https://tableplus.com/blog/2018/10/how-to-start-stop-restart-mysql-server.html" rel="nofollow noreferrer">https://tableplus.com/blog/2018/10/how-to-start-stop-restart-mysql-server.html</a>

blocks|key|1539986|text|正如@gediminas所说的那样|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1539987|系统首选项>服务器>停止MySQL服务器|1539988|是最简单的方法。使用从Oracle下载的二进制安装程序。|1539989|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

As @gediminas said
System Preferences &gt; MySQL &gt; Stop MySQL Server
Was the easiest way. With binary installer downloaded from Oracle.

blocks|key|1754305|text|关于OSX雪豹|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1754306|launchctl+unload+/System/Library/LaunchDaemons/org.mysql.mysqld.plist|code-block|syntax|javascript|1754307|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

On OSX Snow Leopard

<pre><code>launchctl unload /System/Library/LaunchDaemons/org.mysql.mysqld.plist
</code></pre>

blocks|key|1538907|text|如果随MacPorts一起安装了MySQL+5软件包：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1538908|sudo+launchctl++unload+-w+/Library/LaunchDaemons/org.macports.mysql.plist+|code-block|syntax|javascript|1538909|或|1538910|sudo+launchctl++unload+-w+/Library/LaunchDaemons/org.macports.mysql5-devel.plist+|1538911|如果您安装了mysql5-devel软件包。|offset|length|style|CODE|1538912|entityMap^0|0|0|0|0|6|C|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@$M|X|N|Y|O|P]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

If you installed the MySQL 5 package with MacPorts:

<pre><code>sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql.plist 
</code></pre>

Or 

<pre><code>sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5-devel.plist 
</code></pre>

if you installed the <code>mysql5-devel</code> package.

blocks|key|1539363|text|我在macports上安装了mysql5和mysql55。对我来说，这里提到的文件位于以下位置：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1539364|(mysql55-服务器)+/opt/local/etc/LaunchDaemons/org.macports.mysql55-server/org.macports.mysql55-server.plist|1539365|(mysql5)+/opt/local/etc/LaunchDaemons/org.macports.mysql5/org.macports.mysql5.plist|1539366|因此，停止这些工作就像这样：|1539367|mysql55-server：|1539368|sudo+launchctl+unload+-w+/opt/local/etc/LaunchDaemons/org.macports.mysql55-server/org.macports.mysql55-server.plist|code-block|syntax|javascript|1539369|mysql5：|1539370|sudo+launchctl+unload+-w+/opt/local/etc/LaunchDaemons/org.macports.mysql5/org.macports.mysql5.plist+|1539371|您可以使用以下命令检查服务是否仍在运行：|1539372|ps+ax+%7C+grep+mysql|1539373|此外，您可以在此处查看我的案例中的日志文件：|1539374|Mysql55-服务器|1539375|sudo+tail+-n+100+/opt/local/var/db/mysql55/<MyName>-MacBook-Pro.local.err
...
130213+08:56:41+mysqld_safe+mysqld+from+pid+file+/opt/local/var/db/mysql55/<MyName>-MacBook-Pro.local.pid+ended|1539376|1539377|sudo+tail+-n+100+/opt/local/var/db/mysql5/<MyName>-MacBook-Pro.local.err
...
130213+09:23:57++mysqld+ended|1539378|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|18|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|19|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1A|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1B|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1C|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|1D|8|@]|9|@]|A|$]]|$1|Q|3|R|5|L|7|1E|8|@]|9|@]|A|$M|N]]|$1|S|3|T|5|6|7|1F|8|@]|9|@]|A|$]]|$1|U|3|V|5|L|7|1G|8|@]|9|@]|A|$M|N]]|$1|W|3|X|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1I|8|@]|9|@]|A|$]]|$1|10|3|11|5|L|7|1J|8|@]|9|@]|A|$M|N]]|$1|12|3|P|5|6|7|1K|8|@]|9|@]|A|$]]|$1|13|3|14|5|L|7|1L|8|@]|9|@]|A|$M|N]]|$1|15|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|16|$]]

I installed mysql5 and mysql55 over macports. For me the mentioned files here are located at the following places:

(mysql55-server)
/opt/local/etc/LaunchDaemons/org.macports.mysql55-server/org.macports.mysql55-server.plist

(mysql5)
/opt/local/etc/LaunchDaemons/org.macports.mysql5/org.macports.mysql5.plist

So stopping for these works like this:

mysql55-server:

<pre><code>sudo launchctl unload -w /opt/local/etc/LaunchDaemons/org.macports.mysql55-server/org.macports.mysql55-server.plist
</code></pre>

mysql5:

<pre><code>sudo launchctl unload -w /opt/local/etc/LaunchDaemons/org.macports.mysql5/org.macports.mysql5.plist 
</code></pre>

You can check if the service is still running with:

<pre><code>ps ax | grep mysql
</code></pre>

Further you can check the log files in my case here:

mysql55-server

<pre><code>sudo tail -n 100 /opt/local/var/db/mysql55/&lt;MyName&gt;-MacBook-Pro.local.err
...
130213 08:56:41 mysqld_safe mysqld from pid file /opt/local/var/db/mysql55/&lt;MyName&gt;-MacBook-Pro.local.pid ended
</code></pre>

mysql5:

<pre><code>sudo tail -n 100 /opt/local/var/db/mysql5/&lt;MyName&gt;-MacBook-Pro.local.err
...
130213 09:23:57 mysqld ended
</code></pre>

blocks|key|1539433|text|mysql>显示variable_name喜欢‘%25dir%25’的变量；|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1539434|datadir+%7C+/opt/local/var/db/mysql5/|1539435|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

mysql> show variables where variable_name like '%dir%';

| datadir | /opt/local/var/db/mysql5/ |

blocks|key|1539651|text|在尝试了所有这些命令行之后，它不起作用。我必须执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1539652|mv+/usr/local/Cellar/mysql/5.7.16/bin/mysqld+/usr/local/Cellar/mysql/5.7.16/bin/mysqld.bak
mysql.server+stop|code-block|syntax|javascript|1539653|这样一来，mysqld进程就消失了。但是/var/log/system.log有很多垃圾：|1539654|Jul++9+14:10:54+xxx+com.apple.xpc.launchd[1]+(homebrew.mxcl.mysql[78049]):+Service+exited+with+abnormal+code:+1
Jul++9+14:10:54+xxx+com.apple.xpc.launchd[1]+(homebrew.mxcl.mysql):+Service+only+ran+for+0+seconds.+Pushing+respawn+out+by+10+seconds.|1539655|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

After try all those command line, and it is not work.I have to do following stuff:

<pre><code>mv /usr/local/Cellar/mysql/5.7.16/bin/mysqld /usr/local/Cellar/mysql/5.7.16/bin/mysqld.bak
mysql.server stop
</code></pre>

This way works, the mysqld process is gone. but the /var/log/system.log have a lot of rubbish:

<pre><code>Jul 9 14:10:54 xxx com.apple.xpc.launchd[1] (homebrew.mxcl.mysql[78049]): Service exited with abnormal code: 1
Jul 9 14:10:54 xxx com.apple.xpc.launchd[1] (homebrew.mxcl.mysql): Service only ran for 0 seconds. Pushing respawn out by 10 seconds.
</code></pre>

blocks|key|1754696|text|这在具有8.0.12+MySQL的macOS+10.13.6上适用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1754697|/usr/local/mysql/support-files/mysql.server+start|offset|length|style|CODE|1754698|/usr/local/mysql/support-files/mysql.server+restart|1754699|/usr/local/mysql/support-files/mysql.server+stop|1754700|entityMap^0|0|0|1D|0|0|1F|0|0|1C|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@$D|V|E|W|F|G]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|M|$]]

This worked for me on macOS 10.13.6 with 8.0.12 MySQL
<code>/usr/local/mysql/support-files/mysql.server start</code>
<code>/usr/local/mysql/support-files/mysql.server restart</code>
<code>/usr/local/mysql/support-files/mysql.server stop</code>

I installed MySQL via <a href="http://en.wikipedia.org/wiki/MacPorts" rel="noreferrer">MacPorts</a>. What is the command I need to stop the server (I need to test how my application behave when MySQL is dead)?

How do you stop MySQL on a Mac OS install?

日志文件

SQL Server

服务器

MySQL

MacOS

我通过安装了MySQL。我需要什么命令来停止服务器(我需要测试我的应用程序在MySQL死机时的行为)？

问如何在安装Mac时停止MySQL？
EN

回答 20

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在安装Mac时停止MySQL？EN

回答 20

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在安装Mac时停止MySQL？
EN