Re: [cobalt-users] [RaQ3 - mySQL] How to kill mysqld ?? root password forget

["R.Batalla" <cobalt@xxxxxxxxxxxxxxxx>]

Thanks for reply...

||> i guess you could do the above after you've done a
||>
||> # su -
||>
||> or how i managed to kill mysql was thus (also as root)

I do that as admin, root, mysql and other users with same
result. No
permission. :-((

||> # ps -A | grep mysql
||>
||> grab the process ids (pid), and then
||>
||> # kill -9 pid
||> # kill -9 pid
||>
||> etc etc until the stubborn mongrel no longer appears in

Yes, I think to do but mySQL manual say (extracted from):

**********
If you have forgotten the root user password for MySQL, you
can restore it with the following procedure.

1. Take down the mysqld server by sending a kill (not
kill -9)
to the mysqld server.
^^^^^^^^^^^^^
The pid is stored in a .pid file which is normally in the
MySQL database directory:

kill `cat /mysql-data-directory/hostname.pid`

You must be either the Unix root user or the same user the
server runs as to do this.
2. Restart mysqld with the --skip-grant-tables option.
.
.
**********

||> once you've got through that, do your
||>
||> # mysqld -Sg

Unfortunately I can reach this step. It annoys me no end.

R.Batalla
cobalt@xxxxxxxxxxxxxxxx