rpl/r/rpl_user_if_exists.result

106 CREATE USER u3,u4;
108 ALTER USER IF EXISTS u1, u2, u3, u4 ACCOUNT LOCK;
109 CREATE USER IF NOT EXISTS u1, u2, u3, u4;
113 Note	3163	User 'u3'@'%' already exists.
115 DROP USER u1, u2, u3, u4;
118 CREATE USER u3,u4;
120 DROP USER IF EXISTS u1, u2, u3, u4;
125 CREATE USER u1,u2,u3,u4;
127 ALTER USER IF EXISTS u1, u2, u3, u4 ACCOUNT LOCK;
128 CREATE USER IF NOT EXISTS u1, u2, u3, u4;
132 Note	3163	User 'u3'@'%' already exists.
134 DROP USER u1, u2, u3, u4;
136 CREATE USER u1,u2,u3,u4;
138 DROP USER IF EXISTS u1, u2, u3, u4;
143 CREATE USER u3,u4;
148 ALTER USER IF EXISTS u1, u2, u3, u4 ACCOUNT LOCK;
152 CREATE USER IF NOT EXISTS u1, u2, u3, u4;
154 Note	3163	User 'u3'@'%' already exists.
160 DROP USER u3,u4;
162 DROP USER IF EXISTS u1, u2, u3, u4;
170 CREATE USER u3,u4;
171 ALTER USER IF EXISTS u1, u2, u3, u4 ACCOUNT LOCK;
175 CREATE USER IF NOT EXISTS u1, u2, u3, u4;
177 Note	3163	User 'u3'@'%' already exists.
182 DROP USER IF EXISTS u1, u2, u3, u4;
190 CREATE USER u3,u4;
192 ALTER USER IF EXISTS u1, u2, u3, u4 ACCOUNT LOCK;
196 CREATE USER IF NOT EXISTS u1, u2, u3, u4;
198 Note	3163	User 'u3'@'%' already exists.
200 DROP USER u1, u2, u3, u4;
202 CREATE USER u3,u4;
204 DROP USER IF EXISTS u1, u2, u3, u4;
210 CREATE USER u3,u4;
212 ALTER USER IF EXISTS u1, u2, u3, u4 ACCOUNT LOCK;
216 Note	3162	User 'u3'@'%' does not exist.
218 CREATE USER IF NOT EXISTS u1, u2, u3, u4;
221 DROP USER u3,u4;
223 DROP USER IF EXISTS u1, u2, u3, u4;
227 Note	3162	User 'u3'@'%' does not exist.
231 CREATE USER u1,u2,u3,u4;
233 ALTER USER IF EXISTS u1, u2, u3, u4 ACCOUNT LOCK;
237 Note	3162	User 'u3'@'%' does not exist.
239 CREATE USER IF NOT EXISTS u1, u2, u3, u4;
241 DROP USER u1, u2, u3, u4;
243 DROP USER IF EXISTS u1, u2, u3, u4;
247 Note	3162	User 'u3'@'%' does not exist.
259 CREATE USER u3 IDENTIFIED WITH 'mysql_native_password';
260 CREATE USER IF NOT EXISTS u1 IDENTIFIED WITH 'shsh',u2 IDENTIFIED WITH 'sha256_password',u3 IDENTIF…
263 include/assert.inc [assert that u3's auth_plugin has not changed]
267 CREATE USER IF NOT EXISTS u1 IDENTIFIED WITH 'shsh',u2 IDENTIFIED BY 'pass',u3 IDENTIFIED WITH 'sha…
270 include/assert.inc [assert that u3's auth_plugin has not changed]
272 ALTER USER IF EXISTS u1 IDENTIFIED WITH 'shsh',u2 IDENTIFIED BY 'xyz',u3 IDENTIFIED WITH 'sha256_pa…
275 include/assert.inc [assert that u3's auth_plugin has been changed by alter]
277 DROP USER u1,u2,u3;