MySQL Bugs: #104960: A clerical error in the doc of "i_s.user

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:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	8.0	OS:	Any
Assigned to:		CPU Architecture:	Any

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.

Thanks for the report

Posted by developer:
 
The referenced content has been revised. The changes should appear online soon.
Thank you for the bug report.