Error when setting validate_password_mixed_case_count=1

Translated
1

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

Original topic: 配置validate_password_mixed_case_count=1报错

| username: RAIN

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version] 6.1.4
[Reproduction Path] What operations were performed to encounter the issue
[Encountered Issue: Issue Phenomenon and Impact]
Error reported when setting validate_password_mixed_case_count=1

image
image759×54 22.5 KB

[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page

image
image1079×356 62.4 KB

[Attachments: Screenshots / Logs / Monitoring]

image
image759×54 22.5 KB

2
| username: 啦啦啦啦啦 | Original post link

There is no such parameter in 6.1, this should be for MySQL compatibility.

3
| username: 小龙虾爱大龙虾 | Original post link

The parameter name is incorrect. TiDB is not MySQL. The parameter in TiDB is validate_password.mixed_case_count, and it is only available from version 6.5.

4
| username: 路在何chu | Original post link

This version does not support password policies.

5
| username: dba远航 | Original post link

The database has already indicated that it does not recognize this parameter, meaning it is not supported.

6
| username: TiDB_C罗 | Original post link

validate_password.policy introduced from version v6.5.0