Bug #99015 Wrong variables name of password validation

• Submitted: 21 Mar 2020 9:44
• Modified: 23 Mar 2020 15:22
• Reporter: NGUYEN TRUNG HIEU
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8.0.19
• OS: Any
• CPU Architecture: Any

[21 Mar 2020 9:44] NGUYEN TRUNG HIEU

Description:
At this link

https://dev.mysql.com/doc/refman/8.0/en/validate-password-transitioning.html

[mysqld]
validate-password=FORCE_PLUS_PERMANENT
validate_password_dictionary_file=/usr/share/dict/words
validate_password_length=10
validate_password_number_count=2

--> log errors:

[ERROR] [MY-000067] [Server] unknown variable 'validate-password=FORCE_PLUS_PERMANENT'.

[ERROR] [MY-000067] [Server] unknown variable 'validate_password_dictionary_file=...

[ERROR] [MY-000067] [Server] unknown variable 'validate_password_length=10'.

[ERROR] [MY-000067] [Server] unknown variable 'validate_password_number_count=2'.

...

[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19)  MySQL Community Server - GPL.

How to repeat:
[mysqld]
log_error_verbosity=3

tail -f /var/log/mysqld.log

Suggested fix:
Correct variables names are:

validate_password.policy=STRONG # or 2
validate_password.dictionary_file=/path/to/file/max/to/1MiB
validate_password.length=10
validate_password.number_count=2

[21 Mar 2020 10:56] MySQL Verification Team

Hello NGUYEN,

Thank you for the report and feedback.

regards,
Umesh

[23 Mar 2020 15:22] Paul DuBois

Posted by developer:
 
The documentation is correct.

* The refman section is about transitioning from the validate_password plugin to the validate_password component.
* The plugin uses no-dot system variables. The component uses dotted system variables.
* The bug report quotes from the refman section question, which shows some my.cnf lines showing dotless variables. The bug report claims that they are incorrect and should be dotted variables.
* However, the quoted part applies to the plugin, not the component.
* So the variables *should* be dotless and are correct as shown.