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;