Bug #97488 help create user doesn't show new "IDENTIFIED BY RANDOM PASSWORD"
Submitted: 5 Nov 2019 5:59 Modified: 16 Apr 7:39
Reporter: Tsubasa Tanaka (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:8.0.18 OS:Any
Assigned to: 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 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

...