mysqladmin kill 1234

Category: Databases & SQL

mysqladmin kill 1234

Terminate a connection by thread ID

Takes the ID from SHOW PROCESSLIST and kills that connection, aborting its current query — the client receives an error. Useful for stopping runaway statements. Related: mysqladmin processlist.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.