pawiromitchel/*.sql

Created March 3, 2020 14:14

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/pawiromitchel/2e9d7ea9381373b30eb9125e96a08b9d.js"></script>
Save pawiromitchel/2e9d7ea9381373b30eb9125e96a08b9d to your computer and use it in GitHub Desktop.

Download ZIP

Kill all MySQL Queries of a specific user

Raw

SELECT GROUP_CONCAT(CONCAT('KILL ',id,';') SEPARATOR ' ') FROM information_schema.processlist WHERE user = 'user'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment