Differences

This shows you the differences between two versions of the page.

--- mysql:cara-kill-user-mysql [2023/02/27 09:40] – created kbadmin
+++ mysql:cara-kill-user-mysql [2024/10/26 06:05] (current) – kbadmin
@@ Line 7: / Line 7: @@
 jalankan perintah sql tersebut di phpmyadmin atau di server dengan akses root.
+untuk menampilkan daftar id yang akan di kill
+<code>
+select concat('KILL ',id,';') from information_schema.processlist where user='user';
+</code>
 Demikian, semoga bermanfaat.