You can execute the KILL PROCESS statement to terminate a running process.

Syntax

KILL PROCESS process_id      

Parameters

process_id: the ID of the process to terminate. You can query the process ID by executing the SHOW PROCESSLIST statement and checking the ProcessId field.

Permissions

  • You can execute the KILL PROCESS statement to terminate the running processes under your account.
  • A privileged account of a cluster can grant the PROCESS permission to a standard account by executing the GRANT statement. The standard account can then terminate the running processes of all accounts in the cluster.
    GRANT process on *.* to account_name;