Session commands

Show all processes

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'

This is available only in MariaDB 10.3 and higher