我想杀死进程列表中的所有
MySQL进程.有没有办法做到这一点?
# mysqladmin -u root -p processlist
Enter password:
+------+----------------------+---------------------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+----------------------+---------------------+----+---------+------+-------+------------------+
| 1908 | unauthenticated user | 192.168.1.103:46046 | | Connect | | login | |
| 1909 | unauthenticated user | 192.168.1.103:46047 | | Connect | | login | |
| 1910 | unauthenticated user | 192.168.1.103:46048 | | Connect | | login | |
| 1914 | unauthenticated user | 192.168.1.103:46049 | | Connect | | login | |
| 1946 | unauthenticated user | 192.168.1.103:46076 | | Connect | | login | |
| 1954 | unauthenticated user | 192.168.1.103:46078 | | Connect | | login | |
| 2015 | root | localhost | | Query | 0 | | show processlist |
+------+----------------------+---------------------+----+---------+------+-------+------------------+