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.