How to Kill a MySQL process using PHPMyAdmin

MySql Quick Tip

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.