mysql kill specific users all running proccess

If your mysqldump or mysqlcheck stuck on some user database, you can try this:

mysql>

select concat('KILL ',id,';') from information_schema.processlist where user='some_username' into outfile '/tmp/mysql.txt';
source /tmp/mysql.txt;

Leave a Reply

Your email address will not be published. Required fields are marked *