1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
## WL6587 Test --disconnect-on-expired-passwords=default (on)
--source include/not_embedded.inc
SHOW VARIABLES LIKE 'disconnect_on_expired_password';
--echo ## Test mysql client in non-interactrive mode
CREATE USER 'bernt';
SET PASSWORD FOR 'bernt' = PASSWORD('secret');
ALTER USER 'bernt' PASSWORD EXPIRE;
--echo # Attempt to login should fail
--error 1
--exec $MYSQL -ubernt -psecret -e "EXIT" 2>&1
DROP USER 'bernt';
--echo ## Test mysqltest
CREATE USER 'bernt';
SET PASSWORD FOR 'bernt' = PASSWORD('secret');
ALTER USER 'bernt' PASSWORD EXPIRE;
--echo # Login with mysqltest should work
connect(con2,localhost,bernt,secret,,);
--echo # But doing something should fail
--error 1820
SELECT 1;
--echo # Setting password should work
SET PASSWORD = PASSWORD('newsecret');
disconnect con2;
connection default;
DROP USER 'bernt';
--echo ## Test mysqladmin
CREATE USER 'bernt';
SET PASSWORD FOR 'bernt' = PASSWORD('secret');
GRANT ALL ON *.* TO 'bernt' WITH GRANT OPTION;
ALTER USER 'bernt' PASSWORD EXPIRE;
--echo # Doing something should not connect
--replace_result $MYSQLADMIN MYSQLADMIN
--error 1
--exec $MYSQLADMIN -S $MASTER_MYSOCK -P $MASTER_MYPORT --user=bernt --password=secret reload 2>&1
--echo # Setting password should succeed
--exec $MYSQLADMIN --user=bernt --password=secret -S $MASTER_MYSOCK -P $MASTER_MYPORT password newsecret 2>&1
DROP USER 'bernt';
|
