GRANT ALL PRIVILEGES ON *.* TO 'mariadb'@'localhost' IDENTIFIED VIA unix_socket WITH GRANT OPTION

DELIMITER $$

DROP PROCEDURE IF EXISTS mywatch_kill $$

CREATE PROCEDURE mywatch_kill (IN i BIGINT)

  COMMENT 'Kill a query found in information_schema.processlist by ID'

BEGIN

  DECLARE n BIGINT;

  SELECT id INTO n

    FROM information_schema.processlist

    WHERE info IS NOT NULL

    AND host <> '' -- means non-system user

    AND id = i;

  IF (n IS NOT NULL) THEN

    KILL n;

  END IF;

END $$

DELIMITER ;

MariaDB [mysql]> show create procedure mywatch_kill\G

*************************** 1. row ***************************

           Procedure: mywatch_kill

            sql_mode: NO_ENGINE_SUBSTITUTION

    Create Procedure: CREATE DEFINER=`root`@`%` PROCEDURE `mywatch_kill`(IN i BIGINT)

    COMMENT 'Kill a query found in information_schema.processlist by ID'

BEGIN

    DECLARE n BIGINT;

    SELECT id INTO n

      FROM information_schema.processlist

      WHERE info IS NOT NULL

      AND host <> '' 

      AND id = i;

    IF (n IS NOT NULL) THEN

      CALL mysql.rds_kill(n);

    END IF;

  END

character_set_client: utf8

collation_connection: utf8_general_ci

  Database Collation: latin1_swedish_ci

1 row in set (0.00 sec)