| 1 |
# |
| 2 |
# Bug#33822602: Improve MY-010928 your password has expired |
| 3 |
# error on the server to show the user |
| 4 |
# |
| 5 |
# Create test user and expire the password |
| 6 |
CREATE USER u33822602 IDENTIFIED BY 'some_password' PASSWORD EXPIRE; |
| 7 |
# Attempt to connect with expired password should fail |
| 8 |
# if client cannot handle sandbox mode |
| 9 |
mysql: [Warning] Using a password on the command line interface can be insecure. |
| 10 |
Please use --connect-expired-password option or invoke mysql in interactive mode. |
| 11 |
DROP USER u33822602; |
| 12 |
# Check error log for the presence of error message related to password expiry |
| 13 |
Pattern "Password for the account 'u33822602'@'localhost' has expired. To log in, either change it using a client that supports expired passwords or send the change request to an administrator." found |