Ensure your users has the
PROCESS privilege and then run:
SHOW FULL PROCESSLIST
This will list all the operations being performed by threads within the MySQL server. Useful for debugging issues like
too many connections or timeouts.
Kill a thread
Id of the thread that’s problematic and kill it with: