Debian Codegraph @

mysql-test/suite/binlog/r/binlog_user_if_exists.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 SET SESSION sql_log_bin= 0;
7 call mtr.add_suppression("Following users were specified in CREATE USER IF NOT EXISTS");
8 call mtr.add_suppression("Following users were specified in ALTER USER IF EXISTS");
9 SET SESSION sql_log_bin= 1;
10 #
11 # WL#8540: Support IF [NOT] EXISTS clause in CREATE/DROP USER
12 #
13 CREATE USER u1@localhost;
14 CREATE USER IF NOT EXISTS u1@localhost, u2@localhost;
15 Warnings:
16 Note 3163 Authorization ID 'u1'@'localhost' already exists.
17 ALTER USER IF EXISTS u1@localhost ACCOUNT LOCK;
18 DROP USER u1@localhost;
19 DROP USER IF EXISTS u2@localhost;
20 #
21 # Bug #21807286: "CREATE USER IF NOT EXISTS" REPORTS AN ERROR
22 #
23 CREATE USER IF NOT EXISTS b21807286@localhost IDENTIFIED BY 'haha';
24 CREATE USER IF NOT EXISTS b21807286@localhost IDENTIFIED BY 'haha2';
25 Warnings:
26 Note 3163 Authorization ID 'b21807286'@'localhost' already exists.
27 ALTER USER IF EXISTS b21807286@localhost IDENTIFIED BY 'haha3';
28 ALTER USER IF EXISTS b21807286_not_exists@localhost IDENTIFIED BY 'haha4';
29 Warnings:
30 Note 3162 Authorization ID 'b21807286_not_exists'@'localhost' does not exist.
31 DROP USER b21807286@localhost;
32 include/sync_slave_sql_with_master.inc
33 [On Slave]
34 include/show_binlog_events.inc
35 Log_name Pos Event_type Server_id End_log_pos Info
36 slave-bin.000001 # Query # # use `test`; CREATE USER 'u1'@'localhost' IDENTIFIED WITH 'caching_sha2_password'
37 slave-bin.000001 # Query # # use `test`; CREATE USER IF NOT EXISTS 'u1'@'localhost' IDENTIFIED WITH 'caching_sha2_password','u2'@'localhost' IDENTIFIED WITH 'caching_sha2_password'
38 slave-bin.000001 # Query # # use `test`; ALTER USER IF EXISTS 'u1'@'localhost' ACCOUNT LOCK
39 slave-bin.000001 # Query # # use `test`; DROP USER u1@localhost
40 slave-bin.000001 # Query # # use `test`; DROP USER IF EXISTS u2@localhost
41 slave-bin.000001 # Query # # use `test`; CREATE USER IF NOT EXISTS 'b21807286'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
42 slave-bin.000001 # Query # # use `test`; CREATE USER IF NOT EXISTS 'b21807286'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
43 slave-bin.000001 # Query # # use `test`; ALTER USER IF EXISTS 'b21807286'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
44 slave-bin.000001 # Query # # use `test`; ALTER USER IF EXISTS 'b21807286_not_exists'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
45 slave-bin.000001 # Query # # use `test`; DROP USER b21807286@localhost
46 SET SESSION sql_log_bin= 0;
47 call mtr.add_suppression("Following users were specified in CREATE USER IF NOT EXISTS");
48 call mtr.add_suppression("Following users were specified in ALTER USER IF EXISTS");
49 SET SESSION sql_log_bin= 1;
50 include/rpl_end.inc
51
52 End of 5.7 tests!
53