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

[Santiago Montalván <smontalvan@xxxxxxxxxxxxxxxxx>]

I am still having problems resetting the password for MySQL, it is really
driving me insane!

Can you please be more specific as to what commands I need to use.

Thanks, Santiago.


----- Original Message -----
From: "craig" <craig@xxxxxxxxxxxxx>
To: "Santiago Montalván" <smontalvan@xxxxxxxxxxxxxxxxx>
Cc: <cobalt-users@xxxxxxxxxxxxxxx>
Sent: Tuesday, November 12, 2002 1:15 AM
Subject: Re: [cobalt-users] Shutdown mysql...


>
>
> > 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
>
>
>
>
>