Password

Anon

I need to reset My root password as I have lost it!
How do I kill MySQL on my server?

[deleted]

Try reading the manual, and searching the forum.

Anon

Thanks, this wasn't the first port of call - I have all the info for changing the password I just can't find out how to kill the mysql server - it's not listed anywhere, believe me I have looked.

[deleted]

Unix or wind*ws?

Anon

Cobalt Linux.
I got as far as KILL -9 command, but I think this ends all processes(?), and I need to discover the PID for MySQL?

Your help is appreciated

[deleted]

First, If I were you I'd get your system administrator to do it.

Before I tell you how to stop it, do you know how to start it again?

are you the only user of that machine?

Anon

I am the only user of the machine, I was intending to start MySQL again using mysql.server start

[deleted]

and ofcourse you tried 'mysql.server stop'?

Anon

Yes, but i can't access the mysql as root user as I don't have my password so I don't have priveleges to stop MySQL

[deleted]

Ah, so you lost the root password of the system-account'root' and not the password of MySQL's root account..

In that case:

a: you are pretty stupid for losing it.
b: you're f*cked because there is no way of resetting the root password without re-installing the OS.
(that's why system administrators always make a 'backdoor' root account, and why NO server EVER runs as root)

Anon

Yeah, thansk for your constructive help. I lost the root password for MySQL.
I going toask someone who knows.
Thanks.

Anon

Andrew,

Vincent is just being safe. If he tells you how to kill a process and you don't know how to start it up again you just as screwed as you are now not being able to access the database.

From reading this it appears that you are a brand new nix user. I'd really recommend that you get a nix administration book that will help you learn how to administer your system.

To get a list of processes running on your system type:

ps -fe | more

Look for the process named mysql with the lowest PID. Then you can kill -9 that PID. This will stop mysql completely and you'll have to restart it. But you'll need to get the password changed before you can do that since you need the root password to start mysql.

[deleted]

Go look for that piece of paper you wrote the password on.

[deleted]

"Then you can kill -9 that PID. This will stop mysql completely and you'll have to restart it"

Use 'kill -15' unless you like corrupter data files.
And 'kill' only works if you are either the owner if the process, or root.

Anon

Really I didn't realize that -9 would corrupt data. You learn something new every day.

And I'm assuming that Andrew has root access to this box since he was so upset about your previous response about that. ;->

brandonschnell

vincent is right, kill -9 stops processes suddenly and doesn't give them a chance to clean up nicely or stop what they're doing.

andrew did say "I don't have my password so I don't have priveleges to stop MySQL" which implies he doesn't have root access.

resetting the unix root password is simple and only takes a minute or two if you're sitting in front of the box. assuming lilo is installed just reboot and at the lilo prompt type "single". now run "passwd root" and change the root password. failing that, mount the drive on another box and replace the password in /etc/passwd or /etc/shadow with a known password in encryted format. not sure if cobalt has their own way to boot into single user mode.

assuming he does have the root password and can stop mysql, then andrew needs to read the manual:
http://www.mysql.com/doc/R/e/Resetting_permissions.html

[deleted]

kill -9 means 'terminate now, die die die'
and
kill -15 means 'please stop as soon as you can thank you'

And with MySQL being the crap that it is, I would not be suprised if kill -9 wrecked it.

toma42

And with MySQL being the crap that it is, I would not be suprised if kill -9 wrecked it.

Not posting this in defense of mysql, but I've killed both it and pgsql with -s 9 and never (knock on wood) had db corruption.

I'm only a Level 4 Unix admin which is why I didn't know about 15 🙂 (but i do have a magical +5 php editor)

[deleted]

"Not posting this in defense of mysql, but I've killed both it and pgsql with -s 9 and never (knock on wood) had db corruption."

That's good news, but does not mean it's safe or good practice... 🙂