Bug #97488 help create user doesn't show new "IDENTIFIED BY RANDOM PASSWORD"

• Submitted: 5 Nov 2019 5:59
• Modified: 16 Apr 2021 7:39
• Reporter: Tsubasa Tanaka (OCA)
• Status: Closed
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 8.0.18
• OS: Any
• CPU Architecture: Any

[5 Nov 2019 5:59] Tsubasa Tanaka

Description:
Server-side help(help command in mysql command-line client and \help in mysqlsh) 
 doesn't show new "RANDOM PASSWORD" feature.

How to repeat:
mysql> help create user
mysql> help alter user
mysql> help set password

And you can see no "RANDOM" keyword in help message.

Suggested fix:
Reflect new "RANDOM PASSWORD" features to scripts/fill_help_tables.sql

- https://dev.mysql.com/doc/refman/8.0/en/password-management.html#random-password-generatio...
- https://github.com/mysql/mysql-server/blob/mysql-8.0.18/scripts/fill_help_tables.sql

[5 Nov 2019 7:08] MySQL Verification Team

Hello Tanaka-San,

Thank you for the report and feedback.

regards,
Umesh

[16 Apr 2021 7:39] Terje Røsten

Posted by developer:
 
Manual pages have been update and RANDOM PASSWORD feature is documented.

mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 8.0.23    |
+-----------+
1 row in set (0.00 sec)

mysql> help create user
Name: 'CREATE USER'
Description:
Syntax:
CREATE USER [IF NOT EXISTS]
    user [auth_option] [, user [auth_option]] ...
    DEFAULT ROLE role [, role ] ...
    [REQUIRE {NONE | tls_option [[AND] tls_option] ...}]
    [WITH resource_option [resource_option] ...]
    [password_option | lock_option] ...
    [COMMENT 'comment_string' | ATTRIBUTE 'json_object']

user:
    (see )

auth_option: {
    IDENTIFIED BY 'auth_string'
  | IDENTIFIED BY RANDOM PASSWORD

...