Cancel a mysql query
Probably your phpMyAdmin will be stuck showing the "Searching" message. What you can do is to open another tab / open a MySQL session with the console and do the following:
Look for all the processes running:
SHOW PROCESSLIST;
And then kill that specific thread with the KILL
command:
KILL <thread_id>;
Resources:
- SHOW PROCESSLIST page in MySQL
- KILL page in MySQL
Sometimes, you can't even get to phpmyadmin even on a new tab.
If you have access to the environment via command line,
1) log into mysql
mysql -u yourusername -p
2) SHOW PROCESSLIST;
3) KILL <thread_id>;
You could use the KILL
statement : http://dev.mysql.com/doc/refman/5.0/en/kill.html
In phpMyAdmin, go to home page > Status; you'll see a list of your MySQL processes and you have a Kill link for each of them.