summaryrefslogtreecommitdiff
path: root/mysql-test/r/userstat-badlogin-4824.result
blob: 8362e8d5239ea8d8d21f131d3d0c23267f6e4607 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
create user foo@localhost identified by 'foo';
flush user_statistics;
set global userstat=1;
select 1;
1
1
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);
ERROR 28000: Access denied for user 'foo'@'localhost' (using password: YES)
select user, bytes_received from information_schema.user_statistics where user = 'foo';
user	bytes_received
foo	18
drop user foo@localhost;
set global userstat=0;