How can i kill all sessions from a user in mysql using a linux command line command?
I have a user that is using all on my database connections and insted of killing one by one i want to make a script to kill them all !
Linux – Command to Kill All MySQL Sessions from a Specific User
killlinuxMySQL
Best Answer
Try this :
The command will list the processes running in the database and return a
kill 'query id';
command and pipe it into mysql again.Be carefull with this command as there is no rollback form it :)