Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root

Question

I am not sure how to fix this:

dyn-72-33-214-45:python mona$ sudo /usr/local/mysql/bin/mysqld stop
2014-09-06 09:49:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-09-06 09:49:04 22992 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql-5.6.15-osx10.7-x86_64/data/ is case insensitive
2014-09-06 09:49:04 22992 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2014-09-06 09:49:04 22992 [ERROR] Aborting

2014-09-06 09:49:04 22992 [Note] Binlog end
2014-09-06 09:49:04 22992 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

I suppose you wanted to execute ```sudo /etc/init.d/mysql stop``` (an initscript and not the mysqld binary). — MrTux, Sep 06 '14 at 13:53
@Donal /usr/local/mysql/bin/mysqladmin -u root shutdown /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! — Mona Jalal, Sep 06 '14 at 14:02
What do you want to do? Do you want to start or stop it? - Are you sure mysqld is really running? — MrTux, Sep 06 '14 at 14:04
@Donal ps -ef | grep mysqld 501 66888 1 0 18Aug14 ?? 0:00.03 /bin/sh /Applications/MAMP/Library/bin/mysqld_safe --port=8889 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --log-error=/Applications/MAMP/logs/mysql_error_log 501 67004 66888 0 18Aug14 ?? 0:30.92 /Applications/MAMP/Library/bin/mysqld --basedir=/Applications/MAMP/Library --datadir=/Applications/MAMP/db/mysql --plugin- — Mona Jalal, Sep 06 '14 at 14:12
@MonaJalal Can you add that output to your question? OSX may be using a daemon to launch mysql. I have posted an answer that will help you unload it. — Donal, Sep 06 '14 at 14:20

score 92 · Accepted Answer · answered Oct 19 '14 at 12:28

92

I'm using OS X (Yosemite) and this error happened to me when I upgraded from Mavericks to Yosemite. It was solved by using this command

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

answered Oct 19 '14 at 12:28

Mise

2,517
18
19

Wow! Thanks a lot! How did you get to this solution, anyway? (Google found you before any docs :) ) – yair Dec 02 '14 at 12:44
Thank you, this helped me too. – LarsH Apr 04 '15 at 03:22
2

While this solution did work to get MySQL running, it doesn't seem like the most correct solution. The MySQL documentation says the files in this directory are for building the server, not for general usage. https://dev.mysql.com/doc/internals/en/support-files-directory.html – SacWebDeveloper Sep 02 '15 at 21:44
@yair: [here](http://dev.mysql.com/doc/refman/5.7/en/programs-overview.html) is an overview of the different MySQL programs. – Mullefa Dec 11 '15 at 21:04
7

Following this threw a `ERROR! The server quit without updating PID file` error. I looked into /usr/local/mysql/data/*.err file (the name is as per your username) & it pointed that mysqld aborted as it is unable to connect to /tmp/mysql.sock.lock . I had that file already created (as a different user I guess) & I removed it manually. The command now works. – Pocha Feb 02 '16 at 05:23
Works like charm! Thanks! – Willa Mar 15 '16 at 05:58
1

Awesome answer! I can confirm that this one still works with mac os mojave! – skiabox Oct 16 '18 at 11:14

score 17 · Answer 2 · answered Mar 06 '20 at 07:41

17

you might try this if you logged in with root:

mysqld --user=root

answered Mar 06 '20 at 07:41

xiaojueguan

445
4
13

MrTux · Answer 3 · 2014-09-06T14:12:54.120

13

The MySQL daemon should not be executed as the system user root which (normally) do not has any restrictions.

According to your cli, I suppose you wanted to execute the initscript instead:

sudo /etc/init.d/mysql stop

Another way would be to use the mysqladmin tool (note, root is the MySQL root user here, not the system root user):

/usr/local/mysql/bin/mysqladmin --port=8889 -u root shutdown

edited Sep 06 '14 at 14:12

answered Sep 06 '14 at 13:54

MrTux

28,370
24
91
123

3

I am using osx ! `sudo: /etc/init.d/mysql: command not found` – Mona Jalal Sep 06 '14 at 14:01
As you're not using the default port, you have to add your special port to the second command or the socket-path: ```--socket=/Applications/MAMP/tmp/mysql/mysql.sock``` – MrTux Sep 06 '14 at 14:13

score 7 · Answer 4 · answered Jan 31 '18 at 16:43

7

Try this for Amazon Linux AMI or for centOS

sudo service mysqld restart

answered Jan 31 '18 at 16:43

Saurabh Chandra Patel

9,983
3
77
72

IIR `systemctl` is generally preferred in CentOS / RHEL – Martin Jun 10 '18 at 18:25

score 4 · Answer 5 · answered Dec 20 '19 at 08:33

How i resolved this was following the 4th point in this url: https://dev.mysql.com/doc/refman/8.0/en/changing-mysql-user.html

Edit my.cnf
Add user = root under under [mysqld] group of the file

If this doesn't work then make sure you have changed the password from default.

score 1 · Answer 6 · answered Sep 06 '14 at 14:18

1

osx could be using launchctl to launch mysql. Try this:

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

answered Sep 06 '14 at 14:18

Donal

25,862
9
57
70

score 1 · Answer 7 · edited Nov 28 '17 at 16:34

1

Donal had the right solution for me. However, the updated plist name for 2017 is

com.oracle.oss.mysql.mysqld.plist.

edited Nov 28 '17 at 16:34

Machavity

28,730
25
78
91

answered Nov 28 '17 at 16:33

Andy Stutzman

11
2

score 1 · Answer 8 · answered Apr 30 '20 at 01:39

1

I also had the same problem and able to resolve after using below command

/root/mysql-sandboxes/3320/bin/mysqld --defaults-file=/root/mysql-sandboxes/3320/my.cnf  --user=root &

answered Apr 30 '20 at 01:39

Hasitha

518
6
11

score 0 · Answer 9 · answered Feb 28 '18 at 18:52

0

in my case (RHEL7 and MariaDB) this works.

sudo systemctl restart mariadb

answered Feb 28 '18 at 18:52

Leo Mago

11

score 0 · Answer 10 · answered Jan 28 '19 at 01:11

On top of @mise's answer, After I installed MacOS Mojave, I also had to change files ownership on all my MAMP directory and contents).

From the Finder, I went in Application/MAMP, showed files info (cmd + i) and in permissions section added myself with read & write perms, then from the little gear applied to all the children.

score 0 · Answer 11 · answered Feb 23 '19 at 12:19

The correct answer that worked for me on CentOS is

/etc/init.d/mysql restart

which is an init script and not /etc/init.d/mysqld restart, which is binary

The is in fact comment of @MrTux on the question which worked for me. It took quite a bit of my time hence posting it as answer.

score 0 · Answer 12 · answered Dec 23 '19 at 23:12

0

to run mysqld as root user from command line you need to add the switch/options --user=root

mariadb run as system root user

answered Dec 23 '19 at 23:12

Peter

152
1
11

score 0 · Answer 13 · answered Jun 07 '20 at 17:20

0

I had this issue while running MySQL on Minikube (Ubuntu box) and I solved it with:

sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/
sudo apparmor_parser -R /etc/apparmor.d/usr.sbin.mysqld

answered Jun 07 '20 at 17:20

Ivan Bosnic

1,778
5
20
31

score 0 · Answer 14 · answered Dec 17 '20 at 15:00

0

Very weird, but I got this error when I made a typo in the my.cnf file.
So it had nothing to do with the user directive not defined or not running as root-user.

My mistake was:

bind=192.168.1.2

instead of

bind-address=192.168.1.2

answered Dec 17 '20 at 15:00

Tim

1,755
18
17

Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root

14 Answers14

Linked