summaryrefslogtreecommitdiff
path: root/mysql-test/main/userstat-badlogin-4824.result
blob: 757b20e0ce0d87f12f8d8ce264297c229a0a2163 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
set @save_userstat=@@global.userstat;
create user foo@localhost identified by 'foo';
flush user_statistics;
set global userstat=1;
connect foo, localhost, foo, foo;
select 1;
1
1
disconnect foo;
connection default;
select user, bytes_received from information_schema.user_statistics where user = 'foo';
user	bytes_received
foo	18
connect(localhost,foo,bar,test,MASTER_PORT,MASTER_SOCKET);
connect foo, localhost, foo, bar;
ERROR 28000: Access denied for user 'foo'@'localhost' (using password: YES)
connection default;
select user, bytes_received from information_schema.user_statistics where user = 'foo';
user	bytes_received
foo	18
drop user foo@localhost;
set global userstat=@save_userstat;