Bug #106553 ERROR 1095 (HY000) at line 1: You are not owner of thread 15000
Submitted: 24 Feb 2022 3:12 Modified: 24 Feb 2022 14:04
Reporter: hiller hiller Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S3 (Non-critical)
Version:8.0.28 OS:CentOS
Assigned to: CPU Architecture:Any

[24 Feb 2022 3:12] hiller hiller 
Description:
mysql -h127.0.0.1 -urepl -psysrepl
mysql> kill 15000;
ERROR 1095 (HY000): You are not owner of thread 15000

mysql> show grants for repl\G
*************************** 1. row ***************************
Grants for repl@%: GRANT SELECT, RELOAD, PROCESS, SUPER, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO `repl`@`%`
*************************** 2. row ***************************
Grants for repl@%: GRANT FLUSH_TABLES ON *.* TO `repl`@`%`
2 rows in set (0.00 sec)

How to repeat:
mysql -h127.0.0.1 -urepl -psysrepl
mysql> kill 15000;
ERROR 1095 (HY000): You are not owner of thread 15000

mysql> show grants for repl\G
*************************** 1. row ***************************
Grants for repl@%: GRANT SELECT, RELOAD, PROCESS, SUPER, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO `repl`@`%`
*************************** 2. row ***************************
Grants for repl@%: GRANT FLUSH_TABLES ON *.* TO `repl`@`%`
2 rows in set (0.00 sec)
[24 Feb 2022 14:04] MySQL Verification Team 
Hi Mr. hiller,

Thank you for your bug report.

However, your test case is insufficient to be repeatable. Most likely, you are trying to kill a thread / connection that requires a SYSTEM_USER privilege.

Try granting that privilege and it should work.

Can't repeat.