Debian Codegraph @

mysql-test/suite/auth_sec/t/key_rotation.test

raw
1
2 # This test will will check parser support for
3 # ALTER INSTANCE ROTATE <key_type> MASTER KEY statement.
4
5 # Save the initial number of concurrent sessions
6 --source include/count_sessions.inc
7
8 --error ER_PARSE_ERROR
9 ALTER INSTANCE ROTATE BLAH MASTER KEY;
10
11 CREATE USER u1@localhost IDENTIFIED BY 'AbCd13!#';
12
13 --connect(u1_conn, localhost, u1, AbCd13!#)
14 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
15 ALTER INSTANCE ROTATE INNODB MASTER KEY;
16
17 connection default;
18 disconnect u1_conn;
19
20 DROP USER u1@localhost;
21
22 # Wait till all disconnects are completed
23 --source include/wait_until_count_sessions.inc