MySQL Bugs: #79314: HELP not allowed in sandbox

Bug #79314	HELP not allowed in sandbox
Submitted:	17 Nov 2015 14:08	Modified:	18 Nov 2015 4:15
Reporter:	Daniël van Eeden (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Security: Privileges	Severity:	S3 (Non-critical)
Version:	5.7.9, 5.6.29	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
When in the you-must-change-your-password-sandbox the server side help function is not available.

How to repeat:
mysql> show slave status\G
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> help ALTER USER
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Suggested fix:
Allow 'HELP ALTER USER' (or any HELP) while in sandbox mode.

Or add this to the error message:
ALTER USER USER() IDENTIFIED BY '<password>'

Hello Daniël,

Thank you for the report.

Thanks,
Umesh

Still applicable in MySQL-8.0.

On a fresh install you are told about help, but can't use it.

Server version: 8.0.19

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database sbtest;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> help alter user
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.