mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
43 lines
982 B
Text
43 lines
982 B
Text
#
|
|
# MDEV-6896 kill user command cause MariaDB crash!
|
|
#
|
|
create user foo@'127.0.0.1';
|
|
connect con1,127.0.0.1,foo,,;
|
|
connection default;
|
|
select user from information_schema.processlist;
|
|
user
|
|
foo
|
|
root
|
|
kill user foo@'127.0.0.1';
|
|
drop user foo@'127.0.0.1';
|
|
#
|
|
# KILL USER and missing privileges
|
|
#
|
|
create user a@'127.0.0.1';
|
|
create user b@'127.0.0.1';
|
|
grant process on *.* to a@'127.0.0.1';
|
|
grant select on *.* to b@'127.0.0.1';
|
|
connect a,127.0.0.1,a;
|
|
show grants;
|
|
Grants for a@127.0.0.1
|
|
GRANT PROCESS ON *.* TO `a`@`127.0.0.1`
|
|
connect b,127.0.0.1,b;
|
|
show processlist;
|
|
Id User Host db Command Time State Info Progress
|
|
# b # test # # starting show processlist #
|
|
kill user a;
|
|
kill user x;
|
|
connection a;
|
|
show processlist;
|
|
Id User Host db Command Time State Info Progress
|
|
# root # test # # # # #
|
|
# a # NULL # # # # #
|
|
# b # test # # # # #
|
|
kill user b;
|
|
ERROR HY000: Operation KILL USER failed for b@%
|
|
connection default;
|
|
drop user a@'127.0.0.1';
|
|
drop user b@'127.0.0.1';
|
|
#
|
|
# End of 10.3 tests
|
|
#
|