use KILL instead of COM_KILL for MySQL 8.4 support

methane · methane · commit 40303c8c585b · 2025-01-14T16:55:36.000+09:00
diff --git a/.github/workflows/test.yaml b/.github/workflows/test.yaml
@@ -44,6 +44,10 @@ jobs:
             py: "3.10"
             mysql_auth: true
 
+          - db: "mysql:8.4"
+            py: "3.13"
+            mysql_auth: true
+
     services:
       mysql:
         image: "${{ matrix.db }}"
diff --git a/pymysql/connections.py b/pymysql/connections.py
@@ -576,9 +576,9 @@ def affected_rows(self):
         return self._affected_rows
 
     def kill(self, thread_id):
-        arg = struct.pack("<I", thread_id)
-        self._execute_command(COMMAND.COM_PROCESS_KILL, arg)
-        return self._read_ok_packet()
+        if not isinstance(thread_id, int):
+            raise TypeError("thread_id must be an integer")
+        self.query(f"KILL {thread_id:d}")
 
     def ping(self, reconnect=True):
         """
