1CREATE USER 'user1'@'127.0.0.1' IDENTIFIED BY 'password1'; 2CREATE USER 'user22'@'%' IDENTIFIED BY 'password1'; 3CREATE USER '22user'@'LOCALHOST' IDENTIFIED BY 'password1'; 4CREATE USER 'admin'@'%' IDENTIFIED BY 'password1'; 5CREATE USER 'us,er1'@'localhost' IDENTIFIED BY 'password1'; 6SET GLOBAL audit_log_flush=ON; 7SET GLOBAL audit_log_flush=ON; 8SELECT 'user1'; 9user1 10user1 11SELECT 'user22'; 12user22 13user22 14SELECT '22user'; 1522user 1622user 17SELECT 'user22'; 18user22 19user22 20SELECT 'admin'; 21admin 22admin 23SELECT 'us,er1'; 24us,er1 25us,er1 26SET GLOBAL audit_log_flush=ON; 27set global audit_log_flush= ON; 28=================================================================== 29"Connect","<ID>","<DATETIME>","<CONN_ID>",0,"user1","user1","","","localhost","127.0.0.1","test" 30"Query","<ID>","<DATETIME>","select","<CONN_ID>",0,"SELECT 'user1'","user1[user1] @ localhost [127.0.0.1]","localhost","","127.0.0.1","test" 31"Quit","<ID>","<DATETIME>","<CONN_ID>",0,"user1","user1","","","localhost","127.0.0.1","test" 32=================================================================== 33DROP USER 'user1'@'127.0.0.1'; 34DROP USER 'user22'@'%'; 35DROP USER '22user'@'localhost'; 36DROP USER 'admin'@'%'; 37DROP USER 'us,er1'@'localhost'; 38