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.

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

We have an exciting position for someone who wants a challenge...

With Google’s algorithm and ranking rules constantly changing, it can be...

When it comes to content on your website, it is important...

Want to succeed in reaching your target audience through paid advertising?...