MariaDB [(none)]> show grants;
|
+-----------------------------------------------------------------------------------------------------+
|
| Grants for openquery@localhost |
|
+-----------------------------------------------------------------------------------------------------+
|
| GRANT ALL PRIVILEGES ON *.* TO 'openquery'@'localhost' IDENTIFIED VIA unix_socket WITH GRANT OPTION |
|
+-----------------------------------------------------------------------------------------------------+
|
|
|
MariaDB [(none)]> pager grep RENAME
|
PAGER set to 'grep RENAME'
|
MariaDB [(none)]> show processlist;
|
| 1132689 | web | 10.0.1.226:49476 | web_core | Query | 5497 | exit mysqld_lock_tables() | RENAME TABLE rec_db.abilities TO rec_db1447648955.abilities | 0.000 |
|
| 1135244 | web | 10.0.1.226:50465 | web_core | Query | 4783 | Waiting for table level lock | RENAME TABLE rec_db.abilityactions TO rec_db1447649669.abilityactions | 0.000 |
|
| 1137379 | web | 10.0.1.226:52356 | web_core | Query | 3830 | Waiting for table level lock | RENAME TABLE rec_db.abilityreminders TO rec_db1447650622.abilityreminders | 0.000 |
|
100 rows in set (0.00 sec)
|
|
MariaDB [(none)]> kill 1132689;
|
ERROR 1095 (HY000): You are not owner of thread 1132689
|
MariaDB [(none)]> kill 1135244;
|
ERROR 1095 (HY000): You are not owner of thread 1135244
|
MariaDB [(none)]> kill connection 1135244;
|
ERROR 1095 (HY000): You are not owner of thread 1135244
|
Bug
Major