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;
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;