Re: [cobalt-users] Shutdown mysql...

[craig <craig@xxxxxxxxxxxxx>]

> I am trying to kill mysqld so I can reset the root password but I cannot
> takedown the .pid file...  Here is what I have:
>
> [root mysql]# ls
> mysql  mysql.sock  ns1.hostname.com.err  ns1.hostname.com.pid  test
>
> And then I type:
>
> [root /]# kill 'cat /var/lib/mysql/ns1.hostname.com.pid'
> kill: No such pid cat /var/lib/mysql/ns1.hostname.com.pid
>

Heres how I did it when I forgot pass
I simply stopped it with
/etc/rc.d/init.d/mysql stop
Howver when I tried to start it as root with skip grant tabels it
complained so I su mysql
then started it that way changed the pass
then
ps awux |grep mysql
kill -9 the pid
then restarted form root /etc/rc.d/init.d/start