Debian Codegraph @

mysql-test/suite/group_replication/r/gr_random_password.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
7 #-------------------------------------------------
8 # 1. Bootstrap start GR on server1 (Primary).
9 # Start GR on server2 (Secondary).
10 [connection server1]
11 include/start_and_bootstrap_group_replication.inc
12 [connection server2]
13 include/start_group_replication.inc
14
15 include/assert.inc [Verify group_replication_primary_member is SERVER_UUID]
16
17 #-- On Server1
18 [connection server1]
19
20 SELECT @@GLOBAL.generated_random_password_length;
21 @@GLOBAL.generated_random_password_length
22 20
23 SELECT @@SESSION.generated_random_password_length;
24 @@SESSION.generated_random_password_length
25 20
26 SET @@GLOBAL.generated_random_password_length = 25;
27 SELECT @@GLOBAL.generated_random_password_length;
28 @@GLOBAL.generated_random_password_length
29 25
30 SELECT @@SESSION.generated_random_password_length;
31 @@SESSION.generated_random_password_length
32 20
33 #-- CREATE user usr1 with RANDOM PASSWORD
34 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO usr1@localhost;
35 GRANT GROUP_REPLICATION_ADMIN ON *.* TO usr1@localhost;
36 GRANT REPLICATION_SLAVE_ADMIN ON *.* TO usr1@localhost;
37 FLUSH PRIVILEGES;
38 include/rpl_sync.inc
39
40 #-- Connect to usr1 on server1
41 [connection usr1]
42 SELECT CURRENT_USER;
43 CURRENT_USER
44 usr1@localhost
45 SELECT @@GLOBAL.generated_random_password_length;
46 @@GLOBAL.generated_random_password_length
47 25
48 SELECT @@SESSION.generated_random_password_length;
49 @@SESSION.generated_random_password_length
50 25
51
52 #-- On Server2
53 [connection server2]
54 SELECT user FROM mysql.user WHERE user LIKE '%usr%';
55 user
56 usr1
57 SELECT @@GLOBAL.generated_random_password_length;
58 @@GLOBAL.generated_random_password_length
59 20
60 SELECT @@SESSION.generated_random_password_length;
61 @@SESSION.generated_random_password_length
62 20
63
64 #-- On Server1
65 [connection server1]
66 SET @@SESSION.generated_random_password_length = 30;
67 #-- CREATE user usr2 with RANDOM PASSWORD
68 CREATE USER usr2@localhost IDENTIFIED BY RANDOM PASSWORD;
69 user host generated password auth_factor
70 usr2 localhost ##### 1
71 #-- ALTER with RANDOM PASSWORD
72 SELECT @@GLOBAL.generated_random_password_length;
73 @@GLOBAL.generated_random_password_length
74 25
75 SELECT @@SESSION.generated_random_password_length;
76 @@SESSION.generated_random_password_length
77 30
78
79 include/rpl_sync.inc
80
81 #-- Connect to usr2 on server1
82 [connection usr2]
83 SELECT CURRENT_USER;
84 CURRENT_USER
85 usr2@localhost
86 SELECT @@GLOBAL.generated_random_password_length;
87 @@GLOBAL.generated_random_password_length
88 25
89 SELECT @@SESSION.generated_random_password_length;
90 @@SESSION.generated_random_password_length
91 25
92
93 #-- On Server2
94 [connection server2]
95 SELECT user FROM mysql.user WHERE user LIKE '%usr%';
96 user
97 usr1
98 usr2
99 SELECT @@GLOBAL.generated_random_password_length;
100 @@GLOBAL.generated_random_password_length
101 20
102 SELECT @@SESSION.generated_random_password_length;
103 @@SESSION.generated_random_password_length
104 20
105
106 #-- On Server1
107 [connection server1]
108 SET @@GLOBAL.generated_random_password_length = 15;
109 #-- CREATE user usr3 with RANDOM PASSWORD
110 CREATE USER usr3@localhost IDENTIFIED BY RANDOM PASSWORD;
111 user host generated password auth_factor
112 usr3 localhost ##### 1
113 #-- SET PASSWORD with RANDOM PASSWORD
114 SELECT @@GLOBAL.generated_random_password_length;
115 @@GLOBAL.generated_random_password_length
116 15
117 SELECT @@SESSION.generated_random_password_length;
118 @@SESSION.generated_random_password_length
119 30
120
121 include/rpl_sync.inc
122
123 #-- Connect to usr3 on server1
124 [connection usr3]
125 SELECT CURRENT_USER;
126 CURRENT_USER
127 usr3@localhost
128 SELECT @@GLOBAL.generated_random_password_length;
129 @@GLOBAL.generated_random_password_length
130 15
131 SELECT @@SESSION.generated_random_password_length;
132 @@SESSION.generated_random_password_length
133 15
134
135 [connection server2]
136 SELECT user FROM mysql.user WHERE user LIKE '%usr%';
137 user
138 usr1
139 usr2
140 usr3
141 SELECT @@GLOBAL.generated_random_password_length;
142 @@GLOBAL.generated_random_password_length
143 20
144 SELECT @@SESSION.generated_random_password_length;
145 @@SESSION.generated_random_password_length
146 20
147 [connection server1]
148
149 SET @@SESSION.generated_random_password_length = DEFAULT;
150 SET @@GLOBAL.generated_random_password_length = DEFAULT;
151 DROP USER usr1@localhost;
152 DROP USER usr2@localhost;
153 DROP USER usr3@localhost;
154 include/rpl_sync.inc
155 include/group_replication_end.inc