mysql-test/main/password_expiration.test

10 create user user1@localhost;
11 alter user user1@localhost password expire;
18 alter user user1@localhost password expire;
22 drop user user1@localhost;
29 create user user1@localhost password expire;
33 connect(con1,localhost,user1);
38 connect(con1,localhost,user1);
44 drop user user1@localhost;
50 create user user1@localhost password expire;
54 connect(con1,localhost,user1);
56 --exec $MYSQL --connect-expired-password -u user1 -e "set password=password('');"
57 drop user user1@localhost;
62 create user user1@localhost;
63 alter user user1@localhost password expire;
67 connect(con1,localhost,user1);
68 drop user user1@localhost;
73 create user user1@localhost password expire;
74 grant create user on *.* to user1@localhost;
77 connect(con1,localhost,user1);
86 drop user user1@localhost;
92 create user user1@localhost password expire;
96 connect(con1,localhost,user1);
97 drop user user1@localhost;
104 create user user1@localhost password expire;
105 … host, user, JSON_VALUE(Priv, '$.password_last_changed') from mysql.global_priv where user='user1';
106 alter user user1@localhost password expire never;
107 select host, user, JSON_VALUE(Priv, '$.password_lifetime') from mysql.global_priv where user='user1…
108 alter user user1@localhost password expire default;
109 select host, user, JSON_VALUE(Priv, '$.password_lifetime') from mysql.global_priv where user='user1…
110 alter user user1@localhost password expire interval 123 day;
111 select host, user, JSON_VALUE(Priv, '$.password_lifetime') from mysql.global_priv where user='user1…
112 drop user user1@localhost;
118 create user user1@localhost;
119 show create user user1@localhost;
120 alter user user1@localhost password expire;
121 show create user user1@localhost;
122 set password for user1@localhost= password('');
123 alter user user1@localhost password expire default;
124 show create user user1@localhost;
125 alter user user1@localhost password expire never;
126 show create user user1@localhost;
127 alter user user1@localhost password expire interval 123 day;
128 show create user user1@localhost;
129 alter user user1@localhost password expire;
130 show create user user1@localhost;
131 set password for user1@localhost= password('');
132 show create user user1@localhost;
133 drop user user1@localhost;
139 create user user1@localhost password expire interval 0 day;
145 create user user1@localhost;
146 show create user user1@localhost;
148 show create user user1@localhost;
150 alter user user1@localhost password expire;
151 show create user user1@localhost;
153 show create user user1@localhost;
154 set password for user1@localhost= password('');
156 alter user user1@localhost password expire default;
157 show create user user1@localhost;
159 show create user user1@localhost;
161 alter user user1@localhost password expire never;
162 show create user user1@localhost;
164 show create user user1@localhost;
166 alter user user1@localhost password expire interval 123 day;
167 show create user user1@localhost;
169 show create user user1@localhost;
171 alter user user1@localhost password expire;
172 show create user user1@localhost;
174 show create user user1@localhost;
179 connect(con1,localhost,user1);
183 connect(con1,localhost,user1);
191 drop user user1@localhost;
207 create user user1@localhost password expire default;
212     where user='user1';
217 connect(con1,localhost,user1);
218 drop user user1@localhost;
225 create user user1@localhost password expire interval 2 day;
227 connect(con1,localhost,user1);
234     where user='user1';
239 connect(con1,localhost,user1);
240 drop user user1@localhost;
247 create user user1@localhost password expire interval 2 day;
248 alter user user1@localhost password expire never;
253     where user='user1';
257 connect(con1,localhost,user1);
260 drop user user1@localhost;