Debian Codegraph @

mysql-test/suite/group_replication/r/gr_user_admin.result

raw
1 include/group_replication.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 server1]
6 create user 'foo'@'fakehost';
7 create user 'foo'@'fakehost', 'bar'@'fakehost';
8 ERROR HY000: Operation CREATE USER failed for 'foo'@'fakehost'
9 create user 'foo'@'fakehost', 'bar'@'fakehost';
10 ERROR HY000: Operation CREATE USER failed for 'foo'@'fakehost'
11 create user 'foo1'@'fakehost' IDENTIFIED BY 'foo1', 'foo2'@'fakehost'
12 IDENTIFIED WITH 'mysql_native_password' AS '*1111111111111111111111111111111111111111',
13 'foo3'@'fakehost';
14 include/sync_slave_sql_with_master.inc
15 select Host,User from mysql.user where Host='fakehost';
16 Host User
17 fakehost foo
18 fakehost foo1
19 fakehost foo2
20 fakehost foo3
21 rename user 'foo'@'fakehost' to 'foofoo'@'fakehost';
22 rename user 'not_exist_user1'@'fakehost' to 'foobar'@'fakehost', 'bar'@'fakehost' to 'barbar'@'fakehost';
23 ERROR HY000: Operation RENAME USER failed for 'not_exist_user1'@'fakehost','bar'@'fakehost'
24 rename user 'not_exist_user1'@'fakehost' to 'foobar'@'fakehost', 'not_exist_user2'@'fakehost' to 'barfoo'@'fakehost';
25 ERROR HY000: Operation RENAME USER failed for 'not_exist_user1'@'fakehost','not_exist_user2'@'fakehost'
26 include/sync_slave_sql_with_master.inc
27 select Host,User from mysql.user where Host='fakehost';
28 Host User
29 fakehost foo1
30 fakehost foo2
31 fakehost foo3
32 fakehost foofoo
33 drop user 'foofoo'@'fakehost';
34 drop user 'foo1'@'fakehost', 'foo2'@'fakehost', 'foo3'@'fakehost';
35 drop user 'not_exist_user1'@'fakehost', 'barbar'@'fakehost';
36 ERROR HY000: Operation DROP USER failed for 'not_exist_user1'@'fakehost','barbar'@'fakehost'
37 drop user 'not_exist_user1'@'fakehost', 'not_exist_user2'@'fakehost';
38 ERROR HY000: Operation DROP USER failed for 'not_exist_user1'@'fakehost','not_exist_user2'@'fakehost'
39 include/sync_slave_sql_with_master.inc
40 select Host,User from mysql.user where Host='fakehost';
41 Host User
42 #
43 # WL2392: "Change Password at next login" (initial default for root)
44 #
45 CREATE USER must_change2@localhost IDENTIFIED BY 'aha';
46 ALTER USER must_change2@localhost PASSWORD EXPIRE;
47 include/sync_slave_sql_with_master.inc
48 select Host,User,password_expired from mysql.user where user='must_change2';
49 Host User password_expired
50 localhost must_change2 Y
51 # must throw an error
52 SELECT USER();
53 ERROR HY000: You must reset your password using ALTER USER statement before executing this statement.
54 # setting a password unlocks it
55 SET PASSWORD = 'aha2';
56 include/sync_slave_sql_with_master.inc
57 # must not throw an error
58 SELECT USER();
59 USER()
60 must_change2@localhost
61 DROP USER must_change2@localhost;
62 include/sync_slave_sql_with_master.inc
63 include/show_binlog_events.inc
64 Log_name Pos Event_type Server_id End_log_pos Info
65 server-binary-log.000001 # Query # # BEGIN
66 server-binary-log.000001 # Query # # COMMIT
67 server-binary-log.000001 # Query # # BEGIN
68 server-binary-log.000001 # Query # # COMMIT
69 server-binary-log.000001 # Query # # use `test`; CREATE USER 'foo'@'fakehost' IDENTIFIED WITH 'caching_sha2_password'
70 server-binary-log.000001 # Query # # use `test`; CREATE USER 'foo1'@'fakehost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
71 server-binary-log.000001 # Query # # use `test`; rename user 'foo'@'fakehost' to 'foofoo'@'fakehost'
72 server-binary-log.000001 # Query # # use `test`; drop user 'foofoo'@'fakehost'
73 server-binary-log.000001 # Query # # use `test`; drop user 'foo1'@'fakehost', 'foo2'@'fakehost', 'foo3'@'fakehost'
74 server-binary-log.000001 # Query # # use `test`; CREATE USER 'must_change2'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
75 server-binary-log.000001 # Query # # use `test`; ALTER USER 'must_change2'@'localhost' PASSWORD EXPIRE
76 server-binary-log.000001 # Query # # use `test`; ALTER USER 'must_change2'@'localhost' IDENTIFIED WITH 'caching_sha2_password' AS '<non-deterministic-password-hash>'
77 server-binary-log.000001 # Query # # use `test`; DROP USER must_change2@localhost
78 include/group_replication_end.inc