Locked tables in MySQL

[DaisyChain]

Does anyone know how to unlock tables in MySQL when the connection is lost (it was a mysql_pconnect )? I was running a script that locked a couple of tables in my database. This script was interupted before it ran the UNLOCK TABLES query. Now I can't access any of the site that links to the database and when I try to access the tables directly though MySQL-Front it just freezes.
Have tried to run a new script with an UNLOCK query but it hasn't worked (I'm guessing because its not the same connection).

Is my only option to ask for the server to be restarted?

I'd be grateful for any suggestions cos I'm stumped!

[brainpipe]

If you've got privileges, you can try the kill command. It takes a process ID, which you can get using SHOW PROCESSLIST.

[DaisyChain]

Thanks brainpipe. I'm not sure if I have the privileges for that but I can give it a go! Could you talk me through it as I've not used that command before?

[brainpipe]

I'll be glad to help, but you probably won't need me. Check out http://www.mysql.com/doc/en/KILL.html for info on how to do this.

[DaisyChain]

I took the plunge and killed the offending threads(Was a bit worried about making matters worse then they already were!) Thanks for your help - my site is now up and running again.