Mooks Wild Pintos <micahvm@yahoo.com> wrote in news:9af5c963-9a52-420a-
a568-de7cb2206e37@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.