Question

5

how to stop mysql server with root

rated 0 times [ 5] [ 0] / answers: 1 / hits: 17779 / 3 Years ago, wed, june 23, 2021, 12:39:54

How can i stop mysql server (installed using binary installation under /usr/local/mysql)?

When i go in /usr/local/mysql/bin and execute command

mysqld stop i get following error message :

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

[ERROR] Aborting

[Note] mysqld: Shutdown complete

and i can still see process for mysql server.

same happens when i try to do it with mysqld in /etc/init.d.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

oleard

Add To Favorites

Follow

Total Points: 344

Total Questions: 105

Total Answers: 113

Location: Bonaire

Member since Tue, Sep 20, 2022

2 Years ago

answered 3 Years ago luringdge · Accepted Answer

Assuming that you are running an up-to-date Ubuntu and you are already root, as you mentioned, the command is:

service mysql stop

or

/etc/init.d/mysql stop

Because of your installation, you should try this:

sudo -u mysql /usr/local/mysql/bin/mysqld stop