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) 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 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

...

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.