TiDB 7.0 Account Expiration

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb 7.0 账户过期

| username: BigC

【TiDB Usage Environment】
Testing
【TiDB Version】
mysql -uroot -h192.168.56.102 -P4000 -p -e"SET GLOBAL default_password_lifetime = 1"
[tidb@tidb01 ~]$ mysql -uroot -h192.168.56.102 -P4000 -p
Enter password:
Please use --connect-expired-password option or invoke mysql in interactive mode.
[tidb@tidb01 ~]$
[tidb@tidb01 ~]$
[tidb@tidb01 ~]$ mysql -uroot -h192.168.56.102 -P4000 -p --connect-expired-password
Enter password:
Please use --connect-expired-password option or invoke mysql in interactive mode.
[tidb@tidb01 ~]$
[tidb@tidb01 ~]$
【Encountered Problem: Problem Phenomenon and Impact】
Using --connect-expired-password prompt is different from mysql, and unable to change account password.
Is this a usage issue or a bug?
【Resource Configuration】
【Attachments: Screenshots/Logs/Monitoring】

2
| username: caiyfc | Original post link

Is it because this parameter is not set?

3
| username: BigC | Original post link

This can indeed be resolved, but the prompt message is a bit different from MySQL, which was misleading.

4
| username: caiyfc | Original post link

:rofl: I have also been misled by other error reports before.