You can execute the
KILL PROCESS statement to terminate a running process.
KILL PROCESS process_id
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.
- You can execute the
KILL PROCESSstatement 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;