summaryrefslogtreecommitdiff
path: root/mysql-test/main/userstat-badlogin-4824.test
blob: 97370c1d08151fef8abe5d176e555bbcd49ef3c0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
#
# MDEV-4824 userstats - wrong user statistics
#
--source include/not_embedded.inc

create user foo@localhost identified by 'foo';
flush user_statistics;
set global userstat=1;

connect(foo, localhost, foo, foo);
select 1;
disconnect foo;
connection default;

# wait for user_statistics changes to become visible
let $wait_condition= select count(*) = 1 from information_schema.processlist;
--source include/wait_condition.inc

# 41 is for ps-procotol
--replace_result 41 18
select user, bytes_received from information_schema.user_statistics where user = 'foo';

--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
--error ER_ACCESS_DENIED_ERROR
connect(foo, localhost, foo, bar);

connection default;

--replace_result 41 18
select user, bytes_received from information_schema.user_statistics where user = 'foo';

drop user foo@localhost;
set global userstat=0;