How to kill a MySql process using phpMyAdmin
This is just a quick tip on how to kill a MySql process that has become stuck.
This sometimes occurs when an update/create command on a large amount of database entries.
Firstly login to phpmyadmin and find the appropriate database.
Select the SQL tab and in the window enter :
SHOW PROCESSLIST
This will then show all currently running MySql processes.
Just find the process that is stuck and press the <Kill> text to finish that process.
Hopefully this quick tip may help.