How to start MySQL server from command line on Mac OS Lion?

Question

I installed mySQL on my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preferences, I want to know the instructions to start from command-line. I do as follows:

After

su root

I start the mySQL server by command-line, but it produces an error as below:

sh-3.2# /usr/local/mysql/bin/mysqld

111028 16:57:43 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-5.5.17-osx10.6-x86_64/data/ is case insensitive

111028 16:57:43 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

111028 16:57:43 [ERROR] Aborting

111028 16:57:43 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

On macOS, use `mdfind mysql.server` to see where your server executable is — Benjamin Crouzier, Oct 29 '15 at 10:35

score 351 · Answer 1 · edited Dec 15 '15 at 04:14

351

Simply:

mysql.server start

mysql.server stop

mysql.server restart

edited Dec 15 '15 at 04:14

tom10271

3,523
4
28
50

answered Sep 22 '15 at 07:50

user2792249

8,703
3
12
3

14

this is what I got for this one: `. ERROR! The server quit without updating PID file (/usr/local/var/mysql/XXXX.pid).` – nyxee Aug 18 '17 at 08:56
@nyxee You may need to run it with `sudo`! – anuveyatsu Aug 23 '18 at 08:49
I got the same error even with `sudo`. On mac Big Sur and MySQL 5.7, I needed to stop/start with: `sudo launchctl load -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist` and `sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist` – hamx0r Nov 29 '20 at 23:38

score 207 · Accepted Answer · edited Nov 20 '12 at 21:36

207

Try /usr/local/mysql/bin/mysqld_safe

Example:

shell> sudo /usr/local/mysql/bin/mysqld_safe
(Enter your password, if necessary)
(Press Control-Z)
shell> bg
(Press Control-D or enter "exit" to exit the shell)

You can also add these to your bash startup scripts:

export MYSQL_HOME=/usr/local/mysql
alias start_mysql='sudo $MYSQL_HOME/bin/mysqld_safe &'
alias stop_mysql='sudo $MYSQL_HOME/bin/mysqladmin shutdown'

edited Nov 20 '12 at 21:36

Alan

7,006
5
29
38

answered Oct 30 '11 at 08:09

xdazz

154,648
35
237
264

2

It works. But I can't exit the pointer from the performing of the command. How to stop it when the Terminal window is in performing. – vietstone Oct 31 '11 at 01:32
12

Note that this answer does not apply if you installed mysql with Homebrew. – cbmanica Oct 27 '13 at 20:23
For me it ended up being just "mysqld ", the file is located at /usr/local/mysql/bin/mysqld – crobicha Aug 15 '16 at 17:22

score 145 · Answer 3 · edited Feb 14 '15 at 02:54

145

I like the aliases too ... however, I've had issues with MySQLCOM for start ... it fails silently ... My workaround is akin to the others ... ~/.bash_aliases

alias mysqlstart='sudo /usr/local/mysql/support-files/mysql.server start'
alias mysqlstop='sudo /usr/local/mysql/support-files/mysql.server stop'

edited Feb 14 '15 at 02:54

Jordan

5,933
3
22
30

answered Jul 23 '12 at 21:53

Edward J Beckett

4,911
1
39
40

Other answers failed on OSX 10.7.5 w/ latest MySQL install. This one did the trick - thanks! – Irongaze.com Mar 06 '13 at 19:30
Thanks!! I wanted to start mysql and be able to close the terminal as well and this worked. What is the difference between this way of starting it and the mysqld_safe way? – oli206 Mar 25 '13 at 12:18
1

From [mysqld_safe vs mysql.server](http://dev.mysql.com/doc/refman/5.1/en/automatic-start.html) Before mysql.server starts the server, it changes location to the MySQL installation directory, and then invokes mysqld_safe. – Edward J Beckett Mar 26 '13 at 03:10
I did try the command, but it couldn't start, and it seems to be I can't have a pid file. What should I do? – ray6080 Feb 24 '14 at 08:44
@ray6080 , I think you forgot to type `sudo` in front of `./mysql.server start`. From the **support_files** directory, the following command works for me. `sudo ./mysql.server start` – Austin A Mar 10 '15 at 15:26

score 94 · Answer 4 · edited Apr 13 '16 at 17:17

94

As this helpful article states: On OS X to start/stop MySQL from the command line:

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

On Linux start/stop from the command line:

/etc/init.d/mysqld start 
/etc/init.d/mysqld stop 
/etc/init.d/mysqld restart

Some Linux flavours offer the service command too

# service mysqld start 
# service mysqld stop 
# service mysqld restart

or

 # service mysql start 
 # service mysql stop 
 # service mysql restart

edited Apr 13 '16 at 17:17

PandaSobao

23
2
7

answered Nov 06 '12 at 12:31

David

3,523
28
35

no such file or directory from `/usr/local/mysql/support-files/mysql.server stop ` – nyxee Aug 18 '17 at 08:57

Alex K · Answer 5 · 2016-08-13T19:00:02.970

79

If you installed it with homebrew, the binary will be somewhere like

/usr/local/Cellar/mysql/5.6.10/bin/mysqld

which means you can start it with

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

and stop it with

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

Edit: As Jacob Raccuia mentioned, make sure you put the appropriate version of MySQL in the path.

edited Aug 13 '16 at 19:00

answered May 30 '13 at 17:28

Alex K

13,447
4
29
30

1

yeah!!!!!! i didn't realize i installed it this way! make sure you put the appropriate version of mysql in the path – Jacob Raccuia Aug 10 '16 at 17:16

score 42 · Answer 6 · edited Jun 03 '21 at 18:04

42

Maybe your mysql-server didn't start.

You can try

/usr/local/bin/mysql.server start

edited Jun 03 '21 at 18:04

Vega

25,886
26
85
95

answered Dec 09 '13 at 15:15

42wolf

867
8
5

This works on Mac OSX Big Sur as of January 9, 2022! – K M Rakibul Islam Jan 09 '22 at 16:59

score 32 · Answer 7 · edited May 23 '17 at 12:10

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

make alias in .bash_profile

alias start_mysql="/Library/StartupItems/MySQLCOM/MySQLCOM start"
alias stop_mysql="/Library/StartupItems/MySQLCOM/MySQLCOM stop"

and if you are trying to run as root use following safe mode

sudo ./bin/mysqld_safe

if you are still having issues starting, a recommended read: mysql5.58 unstart server in mac os 10.6.5

score 14 · Answer 8 · answered May 12 '17 at 14:16

14

For me this solution worked on mac Sierra OS:

sudo /usr/local/bin/mysql.server start
Starting MySQL
SUCCESS!

answered May 12 '17 at 14:16

shacharsol

2,276
19
14

1

For me, the path was `/usr/local/mysql/support-files/mysql.server` – undevable Dec 29 '21 at 18:43

score 9 · Answer 9 · edited Aug 26 '15 at 11:45

9

If it's installed with homebrew try just typing down mysql.server in terminal and that should be it. AFAIK it executable will be under /usr/local/bin/mysql.server.

If not you can always run following "locate mysql.server" which will tell you where to find such file.

edited Aug 26 '15 at 11:45

gitaarik

36,986
11
91
97

answered Dec 08 '14 at 10:48

Nevio Vesić

367
3
7

score 9 · Answer 10 · answered Jun 10 '16 at 11:27

9

My MySQL is installed via homebrew on OS X ElCaptain. What fixed it was running

brew doctor

which suggested that I run

sudo chown -R $(whoami):admin /usr/local

Then:

brew update
mysql.server start

mysql is now running

answered Jun 10 '16 at 11:27

Merhawi Fissehaye

2,152
1
22
34

Don't know why someone downvoted. This happened to me during a brew update. Running brew doctor, and then following the instructions to add a particular path to my bash profile fixed the issues. Thanks for the suggestion. – Nostalg.io Jul 15 '16 at 02:33

score 5 · Answer 11 · answered Aug 13 '13 at 09:19

5

If you have MySQL installed through Homebrew these commands will help you:

# For starting
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

# For stoping
launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

answered Aug 13 '13 at 09:19

Mario Uher

12,009
4
41
68

4

The LauchAgent for mysql wasn't there by default. Running `brew info mysql` (which I learned from: http://stackoverflow.com/a/4622474/459863) stated that I first had to run `ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents`. After that, it worked. – Wolfram Arnold Nov 11 '13 at 19:47

NIRAJ KUMAR · Answer 12 · 2019-10-31T04:54:27.940

MySql server startup error 'The server quit without updating PID file '

if you have installed mysql from homebrew

close mysql server from preferences of mac

ps ax | grep mysql

#kill all the mysql process running
sudo kill -9 pid

which mysql
/usr/local/bin/mysql
Admins-MacBook-Pro:bin username$ sudo mysql.server start

Starting MySQL
. SUCCESS! 

Admins-MacBook-Pro:bin username$ which mysql

/usr/local/bin/mysql

Admins-MacBook-Pro:bin username$ ps ax | grep mysql

54916 s005  S      0:00.02 /bin/sh 
/usr/local/Cellar/mysql@5.7/5.7.27_1/bin/mysqld_safe --datadir=/usr/local/var/mysql --pid-file=/usr/local/var/mysql/Admins-MacBook-Pro.local.pid
55012 s005  S      0:00.40 /usr/local/Cellar/mysql@5.7/5.7.27_1/bin/mysqld --basedir=/usr/local/Cellar/mysql@5.7/5.7.27_1 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql@5.7/5.7.27_1/lib/plugin --user=mysql --log-error=Admins-MacBook-Pro.local.err --pid-file=/usr/local/var/mysql/Admins-MacBook-Pro.local.pid
55081 s005  S+     0:00.00 grep mysql

score 2 · Answer 13 · answered Nov 29 '20 at 23:39

2

On mac Big Sur and MySQL 5.7, I needed to stop/start with:

sudo launchctl load -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

and

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

This answer came from https://coolestguidesontheplanet.com/start-stop-mysql-from-the-command-line-terminal-osx-linux/

answered Nov 29 '20 at 23:39

hamx0r

3,521
1
31
38

working on macOS monterray for mysql 8.0.28 – Mohsin AR Mar 08 '22 at 19:29

score 0 · Answer 14 · answered Oct 30 '11 at 09:00

0

111028 16:57:43 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

Have you set a root password for your mysql installation? This is different to your sudo root password. Try /usr/local/mysql/bin/mysql_secure_installation

answered Oct 30 '11 at 09:00

Hoppo

1,070
1
13
32

When I ran the above line, it produce: Can't find a 'mysql' client in PATH or ./bin – vietstone Oct 31 '11 at 01:29

How to start MySQL server from command line on Mac OS Lion?

14 Answers14

Linked

Related