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;