How to Kill a MySQL process using PHPMyAdmin

development 5

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.

DSM Design LTD - Brand Logo

Contact Us

Contact DSM Design today for your development queries. You can use our online form or call us on 01202 048079.

Contact Us

Latest News

View all Articles