how to stop mysql server with root

Question

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.

You have elected not to install the mysql package provided by Ubuntu and have instead manually installed a version into `/usr/local` - as such you are not doing things the normal "Ubuntu" way and the advice you get here may be affected. That said, I'm sure people will still try and help as best they can. But as a point of clarification - you should always use the Ubuntu-packaged versions of software unless you have a specific reason not to, and in that case you should mention that reason in your question. — thomasrutter, Apr 15 '14 at 03:01
possible duplicate of [How do I start/stop mysql server?](http://askubuntu.com/questions/82374/how-do-i-start-stop-mysql-server) — Lucio, Oct 28 '14 at 00:40

Frantique · Accepted Answer · 2012-11-28T14:59:39.403

5

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

edited Nov 28 '12 at 14:59

answered Nov 28 '12 at 14:30

Frantique

8,435
35
51

for service mysql stop : it gives following output - > mysql: unrecognized service and for mysql stop : it gives following output - > ERROR 1049 (42000): Unknown database 'stop' – Mangesh Jogade Nov 28 '12 at 14:41
Please specify how did you installed your mysql server, also why you don't use the package version. We cannot really help you like this. Beside this you should run mysql server under mysql user and not as root. This is why it throws you errors. – Frantique Nov 28 '12 at 14:45
i have installed using binary package as described in "http://dev.mysql.com/doc/refman/5.5/en//binary-installation.html" and i am running it under mysql usr "/bin/sh bin/mysqld_safe --user=mysql" – Mangesh Jogade Nov 28 '12 at 14:54
See my edited answer. – Frantique Nov 28 '12 at 15:00
i did that and continuously getting following errors : InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 i am really sorry but i am helpless – Mangesh Jogade Nov 28 '12 at 15:12
1

Forget about binary installation, remove it, and install mysql server with `sudo apt-get install mysql-server` – Frantique Nov 28 '12 at 15:21
let us [continue this discussion in chat](http://chat.stackexchange.com/rooms/6537/discussion-between-mangesh-jogade-and-frantique) – Mangesh Jogade Nov 28 '12 at 15:27

score 2 · Answer 2 · answered Nov 28 '12 at 13:25

2

Use sudo mysqld stop to stop it as root.

hope it helped.

answered Nov 28 '12 at 13:25

denNorske

965
8
31

error occurred when i executed with root. – Mangesh Jogade Nov 28 '12 at 13:27
Then, are you sure you are in the sudo'ers file? That you are allowed to use "sudo" ? Find the process and kill it with `pkill`, find it by reading the list on `ps -e`. – denNorske Nov 28 '12 at 13:34
1) i was looged in as root 2) i can kill the process, but why i am not able to stop it with mysqld ? is it any bug??? – Mangesh Jogade Nov 28 '12 at 13:38
mysqld is the file that runs, you can end the file, but the process will remain running in the background. So you just have to kill the process manually. – denNorske Nov 28 '12 at 13:43
i want to stop it using mysqld only. – Mangesh Jogade Nov 28 '12 at 13:47
sorry, but i dont have any idea how to do that if that above didnt work. Yeah, sorta bug if you ask me. – denNorske Nov 28 '12 at 14:04

score 2 · Answer 3 · answered Nov 28 '12 at 13:26

2

sudo /etc/init.d/mysqld stop

should do it.

answered Nov 28 '12 at 13:26

GaryBishop

894
6
10

i am already a root – Mangesh Jogade Nov 28 '12 at 13:28

thomasrutter · Answer 4 · 2014-04-15T03:11:20.447

You have elected not to install the mysql package provided by Ubuntu and have instead manually installed a version into /usr/local - as such you are not doing things the normal "Ubuntu" way and the advice you get here may be affected.

The normal way of install MySQL in Ubuntu is by installing the package provided by Ubuntu using something like sudo apt-get install mysql-server. Installing something manually into /usr/local with a make or install script should be something done only when you have a specific reason to do so and you have a greater level of technical skill and knowledge, and willingness to set it up correctly yourself. You'll also need to do updates and security patches manually because it won't be done by Ubuntu.

Based on your level of technical knowledge of Ubuntu I don't think installing something manually into /usr/local is for you. Unless you respond with a good reason for not being able to use the one included with Ubuntu and you really want to learn more, I'd advise removing that MySQL and installing the Ubuntu one with sudo apt-get install mysql-server.

After doing this, you'll be able to follow all the normal instructions you find on the Ubuntu wikis and howtos.

score -2 · Answer 5 · answered Apr 15 '14 at 02:09

-2

try the following:

quit;

this worked for me...then i just got the msg: "bye". then it was showing again to enter a comand as the USER@user>, not as MYSQL>. Help this works!

answered Apr 15 '14 at 02:09

pedro najera

1

This shows how to quit the command line client but the question is about how to stop the server. – Florian Diesch Apr 15 '14 at 03:26

how to stop mysql server with root

5 Answers5