MariaDB provides a command to kill a specific session on a server.
Find session ID
First we will identify the session we want to end using any of the queries below:
Option 1 - Show statement
Option 2 - Generic query
select id, user, host, db, command, time, state, info, progress from information_schema.processlist;
Now we will use the session ID (Id) to kill a specific session (2 in this example):
MySQL ends session and all operations associated with it are aborted if you are not using transactions. This operation could take a while.
Query OK, 0 rows affected (0.01 sec)