== Quote from Ana C. Dent (anacedent@hotmail.com)'s article
> Mooks Wild Pintos <micahvm@yahoo.com> wrote in
> news:3e17d10f-be42-4ac6-88bb-d90cab5afdb9@s12g2000prg.googlegroups.com:
> > On Dec 3, 10:27 am, Good Man <he...@letsgo.com> wrote:
> >> Mooks Wild Pintos <mica...@yahoo.com> wrote in
> >> news:9af5c963-9a52-420a-
> >> a568-de7cb2206...@e1g2000hsh.googlegroups.com:
> >>
> >> > Hi,
> >> > Is there a script or command that I can use on a Windows MySQL
> >> > server to kill a thread by user id from a remote computer? The
> >> > vendor application we are using only allows one MySQL thread by a
> >> > certain user id and if that process hangs we need to manually go
> >> > into the MySQL Administrator and kill the thread. I would like to
> >> > automate this if possible.
> >>
> >> I suppose the "if that process hangs" should be of greater concern
> >> than trying to automate a thread-kill (which is pretty serious action
> >> to be 'automated').
> >>
> >> Why would your process hang? That's the question to solve; you
> >> shouldn't be experiencing problems on that level without a full
> >> inquiry into the cause.
> >
> >
> > Unfortunately it is a vendor's application and they refuse to fix the
> > issue. The application is used 24x7 and is mission critical so when
> > it hangs and doesn't close correctly I get a late night call to
> > connect to the server and kill the proper thread. So can it be done?
> > If so please let me know and I'll worry about the consequences.
> >
> I've written a PHP form that allows folks to kill their own sessions.
> Also if V5 MYSQL you could write a stored procedure to pull the trigger.

you don't need any of these. they are nice to have but to kill a user session, you
can use mysql administrator gui program. after login, click on the connections and
then click on the "by user" tab. see if you can use this.
--
POST BY: lark with PHP News Reader ;o)