How do you stop MySQL on a Mac OS install?

Question

I installed MySQL via MacPorts. What is the command I need to stop the server (I need to test how my application behave when MySQL is dead)?

mloughran · Accepted Answer · 2020-06-16T11:05:52.903

513

There are different cases depending on whether you installed MySQL with the official binary installer, using MacPorts, or using Homebrew:

Homebrew

brew services start mysql
brew services stop mysql
brew services restart mysql

MacPorts

sudo port load mysql57-server
sudo port unload mysql57-server

Note: this is persistent after a reboot.

Binary installer

sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart

edited Jun 16 '20 at 11:05

answered Sep 19 '08 at 14:08

mloughran

11,415
7
28
22

1

Thanks a ton - I had the stop and start commands, but didn't know about/think about trying restart. After using the stop command, start would do nothing, as would starting from the MySQL System Preferences panel. – Ross Henderson Apr 16 '11 at 01:00
4

In my case it was slightly different, because the mysql version number was added in the plist file. It was like that: sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist – d1rk Oct 26 '11 at 10:23
1

And for me, /opt/local/etc/LaunchDaemons/org.macports.mysql5/org.macports.mysql5.plist – Dmitry Minkovsky Jun 30 '12 at 21:00
11

And for homebrew: `launchctl (un)load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist` – Kostas Jun 12 '13 at 12:48
@vrinek Tahnk you - That did it for me - Except the file is `~/Library/LaunchAgents/com.mysql.mysqld.plist` – troelskn Aug 01 '13 at 10:02
Why not just `sudo mysql.server stop` etc.? Any proper installation, regardless of method, should have put that in your PATH. I've installed through Homebrew and mentioned short form works fine. – Markus Amalthea Magnuson Jun 03 '14 at 13:18
2

If you have [Homebrew Services](https://github.com/Homebrew/homebrew-services) installed, you can use `brew services stop mysql` and `brew services start mysql`. (Also `restart`, and `run` which starts for the current session only.) – medmunds May 27 '17 at 18:14
@MarkusAmaltheaMagnuson I get `.. ERROR! The server quit without updating PID file (/usr/local/var/mysql/TRSS-MacBook-Pro.local.pid).` but not with the `launchctl` or `brew services` approach. – trss Jul 26 '17 at 13:30
Didn't work for me. Kept getting this error: /Users/charlie/Library/LaunchAgents/homebrew.mxcl.mysql.plist: No such file or directory – 2myCharlie Aug 01 '18 at 20:14
This worked for me ```sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist``` – Winnipass Aug 27 '19 at 01:38

pjammer · Answer 2 · 2015-04-23T22:26:04.840

146

For those who used homebrew to install MySQL use the following commands below to start, stop, or restart MySQL

Brew start

/usr/local/bin/mysql.server start

Brew restart

/usr/local/bin/mysql.server restart

Brew stop

/usr/local/bin/mysql.server stop

edited Apr 23 '15 at 22:26

answered Jan 18 '12 at 16:40

pjammer

9,489
5
46
56

5

For me, the install directory by homebrew is `/usr/local/Cellar/mysql@5.7/5.7.23/bin/` – Moobie Jan 29 '19 at 08:45

score 79 · Answer 3 · answered Sep 19 '08 at 10:24

79

You can always use command "mysqladmin shutdown"

answered Sep 19 '08 at 10:24

Rimantas

1,471
9
6

1

The commands above didn't work for me. This one did. Not sure what the difference is in my setup, but thanks. – Marco Sep 06 '09 at 01:10
2

Even though it may work, if you're using MacPorts and run this, launchctl will not realize mysql has stopped and will complain if you try to start it (load). Using launchctl is thus preferable. – lambshaanxy Jul 06 '11 at 02:22
1

Also although this works for shutting down the server, it won't do anything to help you bring it back up when you want to restart it. – aroth Aug 09 '11 at 01:59
4

Remember to add -p and enter your mysql root password when prompted. At my setup where mysql is installed with MacPorts mysql restarted, and reloaded the config, which was the target for my action. – Jesper Grann Laursen Nov 26 '13 at 20:58
1

`sudo /opt/local/lib/mysql56/bin/mysqladmin shutdown` if your mysql comes from MacPorts – Alain Tiemblo Nov 28 '14 at 20:12
Works fine for homebrew installed mysql. I had to execute the command as sudo (i.e. `sudo mysqladmin shutdown`) – Staccato Sep 14 '15 at 06:15
This is the only one that worked for me. I just needed to add `sudo` to the beginning. – Nick Manning Mar 06 '16 at 22:02
I got this error for the above command: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'lorcz'@'localhost' (using password: NO)' – 2myCharlie Aug 01 '18 at 20:15

score 57 · Answer 4 · answered May 13 '16 at 13:43

57

If you are using homebrew you can use

brew services restart mysql
brew services start mysql
brew services stop mysql

for a list of available services

brew services list

answered May 13 '16 at 13:43

Jan

12,992
9
53
89

3

This worked for me, even after interacting with launchctl directly did not. Thank you! – Lyndsy Simon Dec 14 '16 at 23:41
@Jan omg, thank you so much, your answer helped a lot – whitesiroi Jul 06 '21 at 02:20
1

This worked but I have to specify MySQL version with it. brew services restart mysql@5.7 – Abrar Ahmad Nov 12 '21 at 05:27

score 27 · Answer 5 · answered Apr 13 '20 at 08:02

27

In my case, it kept on restarting as soon as I killed the process using PID. Also brew stop 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.

answered Apr 13 '20 at 08:02

Abhijeet Khangarot

1,281
1
16
25

2

Worked for direct install through .pkg, version 8.0.27-arm64 on Big Sur. – SagarM Nov 20 '21 at 06:08

Moesio · Answer 6 · 2013-03-05T19:58:54.160

23

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

edited Mar 05 '13 at 19:58

answered Aug 16 '12 at 16:52

Moesio

3,100
1
27
36

3

+1 this was only one that worked for me---I just used the DMG installer from Mysql. Thanks – Dolan Antenucci Feb 09 '13 at 15:20
1

for me its giving this error. `$ sudo /usr/local/mysql/support-files/mysql.server stop ERROR! MySQL server PID file could not be found! ` – codeaprendiz Jan 07 '21 at 12:45
1

This is the only one that works for me. Thanks a lot! – Chen Ni Sep 27 '21 at 12:00

score 15 · Answer 7 · answered Jan 12 '10 at 21:48

15

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

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

answered Jan 12 '10 at 21:48

katy lavallee

2,741
1
28
26

1

This is how you're supposed to do it.. For MacPorts.. The `launchctl` method does NOT work, and in fact can cause problems with PID / DB startup bitching and moaning. – Alex Gray Mar 13 '12 at 04:01

score 12 · Answer 8 · edited Apr 21 '13 at 08:35

12

Apparently you want:

sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop

Have a further read in Jeez People, Stop Fretting Over Installing RMagic.

edited Apr 21 '13 at 08:35

Peter Mortensen

30,738
21
105
131

answered Sep 19 '08 at 10:23

Dan

61,568
9
61
78

score 11 · Answer 9 · edited Sep 03 '13 at 19:40

11

Use:

sudo mysqladmin shutdown --user=*user* --password=*password*

One could probably get away with not using sudo. The user could be root for example (that is, the MySQL root user).

edited Sep 03 '13 at 19:40

Peter Mortensen

30,738
21
105
131

answered Jul 08 '13 at 11:56

Steve

696
7
15

zack · Answer 10 · 2013-04-21T22:17:39.513

Try

sudo <path to mysql>/support-files/mysql.server start
sudo <path to mysql>/support-files/mysql.server stop

Else try:

sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop<br>
sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart

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

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

PS: I also found that I needed to unload the .plist to get an unrelated install of MAMP-MySQL to start / stop correctly. After running running this, MAMP-MySQL starts just fine:

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

score 9 · Answer 11 · answered Mar 22 '16 at 03:38

9

On my mac osx yosemite 10.10. This command worked:

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

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

answered Mar 22 '16 at 03:38

Duc Chi

391
4
8

2

This is only way that worked for me. For any other methods, the `mysqld` process restarts immediately after stopped. – Rockallite Jun 07 '16 at 01:01
This is the only way which worked for me too. I switched from homebrew to the MySQL-supplied DMG and I think possibly the brew version was still running even though I uninstalled it. – Sam Critchley Jan 18 '17 at 09:43

score 5 · Answer 12 · answered Jun 23 '16 at 14:13

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. https://dev.mysql.com/doc/refman/5.6/en/osx-installation-launchd.html

score 5 · Answer 13 · answered Jul 21 '21 at 11:19

Get instance name:

ls /Library/LaunchDaemons | grep mysql

Stop MySQL instance (Works on MacOS Catalina, MySQL 8):

sudo launchctl unload /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

Or, you can Stop MySQL instance in

MacOS Settings > MySQL > Stop MySQL Server

Also, check here for more methods: https://tableplus.com/blog/2018/10/how-to-start-stop-restart-mysql-server.html

score 4 · Answer 14 · edited Jan 21 '14 at 20:48

4

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

That is,

ps -Af

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

edited Jan 21 '14 at 20:48

Aleks G

56,435
29
168
265

answered Sep 19 '08 at 10:26

John Montgomery

8,868
4
33
43

yeah.. this one is the best and universal for scripting. Do you think there is possibility of data corruption? or any other problems? – user425720 Nov 11 '10 at 19:01
1

This has the potential for data corruption. – Dan Sandland Dec 10 '15 at 21:46
But as a last ditch effort, this is adequate. – Dan Sandland Dec 10 '15 at 21:57

score 3 · Answer 15 · answered Jul 22 '21 at 14:56

3

As @gediminas said

System Preferences > MySQL > Stop MySQL Server

Was the easiest way. With binary installer downloaded from Oracle.

answered Jul 22 '21 at 14:56

Jaime Bula

51
3

score 3 · Answer 16 · answered Jan 26 '23 at 19:00

3

For Mac M1 Pro, Go to system settings and Mysql at the bottom, Then click on stop MySQL server:

answered Jan 26 '23 at 19:00

Upasana Mittal

2,480
1
14
19

score 2 · Answer 17 · answered Oct 15 '15 at 09:15

2

On OSX Snow Leopard

launchctl unload /System/Library/LaunchDaemons/org.mysql.mysqld.plist

answered Oct 15 '15 at 09:15

sweetfa

5,457
2
48
62

score 2 · Answer 18 · answered Nov 30 '20 at 10:51

2

For me the following solution worked Unable to stop MySQL on OS X 10.10

To stop the auto start I used:

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

And to kill the service I used:

sudo pkill mysqld

answered Nov 30 '20 at 10:51

codeaprendiz

2,703
1
25
49

score 2 · Answer 19 · answered Jun 30 '11 at 10:09

2

For me it's working with a "mysql5"

sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist
sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist

answered Jun 30 '11 at 10:09

Allisone

8,434
4
32
54

score 1 · Answer 20 · edited Apr 21 '13 at 08:35

1

If you installed the MySQL 5 package with MacPorts:

sudo launchctl  unload -w /Library/LaunchDaemons/org.macports.mysql.plist

Or

sudo launchctl  unload -w /Library/LaunchDaemons/org.macports.mysql5-devel.plist

if you installed the mysql5-devel package.

edited Apr 21 '13 at 08:35

Peter Mortensen

30,738
21
105
131

answered Sep 19 '08 at 10:24

Bartosz Blimke

6,498
3
24
19

1

This will stop it from starting when you reboot, which is not what the poster was asking for. – Matthew Schinckel Sep 19 '08 at 10:27

score 1 · Answer 21 · answered Jul 09 '18 at 06:12

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

mv /usr/local/Cellar/mysql/5.7.16/bin/mysqld /usr/local/Cellar/mysql/5.7.16/bin/mysqld.bak
mysql.server stop

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

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.

score 1 · Answer 22 · answered Aug 24 '20 at 04:41

1

This worked for me on macOS 10.13.6 with 8.0.12 MySQL

/usr/local/mysql/support-files/mysql.server start

/usr/local/mysql/support-files/mysql.server restart

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

answered Aug 24 '20 at 04:41

Szekelygobe

2,309
1
19
25

score 0 · Answer 23 · answered Feb 13 '13 at 08:38

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:

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

mysql5:

sudo launchctl unload -w /opt/local/etc/LaunchDaemons/org.macports.mysql5/org.macports.mysql5.plist

You can check if the service is still running with:

ps ax | grep mysql

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

mysql55-server

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

mysql5:

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

score 0 · Answer 24 · answered Apr 03 '14 at 21:31

0

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

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

answered Apr 03 '14 at 21:31

Jack Peng

576
5
19

How do you stop MySQL on a Mac OS install?

24 Answers24

Homebrew

MacPorts

Binary installer

Linked