Debian Codegraph @

mysql-test/suite/binlog/t/binlog_rewrite.test

raw
1
2 #
3 # WL#5706/Bug#58712/Bug#11746378
4 # Encrypt or remove passwords from slow, query, and binary logs
5 # (see sql/sql_rewrite.cc for bulk of implementation)
6 #
7
8 -- source include/have_log_bin.inc
9
10 RESET MASTER;
11
12 #--------------- bin log -------------------------------------------
13
14 # misc rewrites.
15
16 # Show that when we completely re-synthesize commands,
17 # we get all the particles right!
18
19 CREATE USER user1@localhost IDENTIFIED BY 'secret';
20 CREATE USER user2@localhost IDENTIFIED BY 'secret';
21 SET PASSWORD FOR user1@localhost = 'secret';
22
23 --echo # Test the password is encrypted in binary log
24 --echo # with alter user
25 ALTER USER user1@localhost IDENTIFIED BY 'secret';
26 ALTER USER user1@localhost IDENTIFIED BY 'secret', user2@localhost IDENTIFIED BY 'secret2' /*before with*/WITH/*after with*/MAX_QUERIES_PER_HOUR 90;
27 ALTER USER user1@localhost IDENTIFIED BY 'secret', user2@localhost IDENTIFIED BY 'secret2' /*before require*/REQUIRE SSL/*after require*/ /*before with*/WITH/*after with*/MAX_QUERIES_PER_HOUR 90;
28 ALTER USER user1@localhost IDENTIFIED BY 'secret', user2@localhost IDENTIFIED BY 'secret2';
29
30 GRANT UPDATE ON *.* TO user1@localhost WITH GRANT OPTION;
31 GRANT UPDATE ON *.* /*before to*/TO/*after to*/ user1@localhost;
32 GRANT UPDATE ON *.* /*before to*/TO/*after to*/ user1@localhost;
33 GRANT UPDATE ON *.* TO user1@localhost, user2@localhost;
34 REVOKE UPDATE ON *.* FROM user1@localhost, user2@localhost;
35
36 CREATE PROCEDURE p1() SQL SECURITY INVOKER SELECT 1;
37 GRANT EXECUTE ON PROCEDURE p1 TO user1@localhost, user2@localhost;
38 GRANT EXECUTE ON PROCEDURE p1 /*before to*/TO/*after to*/ user1@localhost, user2@localhost;
39 GRANT EXECUTE ON PROCEDURE p1 TO user1@localhost, user2@localhost;
40 REVOKE EXECUTE ON PROCEDURE p1 FROM user1@localhost, user2@localhost;
41
42 CREATE FUNCTION f1() RETURNS INT RETURN 123;
43 GRANT EXECUTE ON FUNCTION f1 /*before to*/TO/*after to*/ user1@localhost/*!10000 , user2@localhost*/ /*!99999 THIS_WOULD_BREAK */;
44 REVOKE EXECUTE ON FUNCTION f1 FROM user1@localhost, user2@localhost;
45
46 DROP USER user1@localhost, user2@localhost;
47 DROP FUNCTION f1;
48 DROP PROCEDURE p1;
49
50 # 1.1.1.1
51 CREATE USER test_user1 IDENTIFIED BY 'azundris1';
52 GRANT ALL on *.* TO test_user1;
53
54 # 1.1.1.2
55 CREATE USER test_user2 IDENTIFIED BY 'azundris2';
56
57 # 1.1.1.3
58 CHANGE REPLICATION SOURCE TO SOURCE_PASSWORD='azundris3';
59
60 # 1.1.1.4
61 CREATE USER 'test_user4'@'localhost';
62 SET PASSWORD FOR 'test_user4'@'localhost' = 'azundris4';
63
64 --let $mask_user_password_events=1
65 --let $mask_grant_as_events=1
66 --source include/show_binlog_events.inc
67 --let $mask_user_password_events=0
68
69 DROP USER 'test_user4'@'localhost';
70 DROP USER test_user2;
71 DROP USER test_user1;
72
73 RESET MASTER;
74 RESET SLAVE;
75 --echo End of 5.6 tests!