Bug #104960 A clerical error in the doc of "i_s.user_attributes table"
Submitted: 16 Sep 15:05 Modified: 21 Oct 12:49
Reporter: Xiaofeng Dong Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[16 Sep 15:05] Xiaofeng Dong
Description:
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-attributes-table.html

For example, the statement CREATE USER 'bill'@'localhost' COMMENT 'A comment' ATTRIBUTE '{"foo": "bar", "bazz": "fazz"}' adds the following row to the USER_ATTRIBUTES table:

This example is not appropriate.Executing it will get an error.

How to repeat:
Reference documents:

https://dev.mysql.com/doc/refman/8.0/en/alter-user.html#alter-user-comments-attributes

MySQL 8.0.21 and higher supports user comments and user attributes, as described in Section 13.7.1.3, “CREATE USER Statement”. These can be modified employing ALTER USER by means of the COMMENT and ATTRIBUTE options, respectively. You cannot specify both options in the same ALTER USER statement; attempting to do so results in a syntax error.
[17 Sep 10:37] MySQL Verification Team
Thanks for the report
[21 Oct 12:49] Daniel Price
Posted by developer:
 
The referenced content has been revised. The changes should appear online soon.
Thank you for the bug report.