show processlist
Alternatively a query can be used:
select id,user, host, db, command, time, state, info, progress from information_schema.processlist
kill 100
100 is the process id listed above.
To run queries with Oracle syntax, you can use:
SET SESSION sql_mode='ORACLE'