Some mysql tips

From the mysql> prompt type

show processlist;

To show the list of mysql processes, with their process id numbers in the first column.

If you want to kill say, process 657, just type

kill 657

from Interesting things to know about MySQL