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

[16 Sep 2021 15:05] Xiaofeng Dong

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:


MySQL 8.0.21 and higher supports user comments and user attributes, as described in Section, “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 2021 10:37] MySQL Verification Team
Thanks for the report
[21 Oct 2021 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.