locking - Need to clear MySQL InnoDB lock without restarting database -

i have mysql innodb lock preventing user logging in. don't care cause of lock @ moment - need clear lock without restarting database. killing query process nothing fyi. suggestions? thanks.

here how wound solving problem:

mysql> show engine innodb status\g *************************** 1. row ***************************   type: innodb   name:  status:  ===================================== 120710 18:05:37 innodb monitor output ===================================== per second averages calculated last 37 seconds ---------- semaphores ---------- os wait array info: reservation count 208374, signal count 196902 mutex spin waits 0, rounds 39211638, os waits 80663 rw-shared spins 588505, os waits 68505; rw-excl spins 3204502, os waits 53586 ------------ transactions ------------ trx id counter 1 3626791829 purge done trx's n:o < 1 3625948819 undo n:o < 0 0 history list length 6754 list of transactions each session: ... ---transaction 1 3625948818, active 2892 sec, process no 1981, os thread id 140020625811200 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1  >>>>> mysql thread id 14982, query id 232584561 localhost dbuser  trx read view not see trx id >= 1 3625948819, sees < 1 3625948817  mysql> kill 14982; query ok, 0 rows affected (0.00 sec) 

note line >>>>> mysql thread id defined - thread should killed.

please see this post - useful.