MySQL Bugs: #88835: SHOW CREATE USER output not backwards compatible

Bug #88835	SHOW CREATE USER output not backwards compatible
Submitted:	8 Dec 2017 11:47	Modified:	8 Dec 2017 12:23
Reporter:	Daniël van Eeden (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Security: Privileges	Severity:	S3 (Non-critical)
Version:	8.0.3	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When running SHOW CREATE USER on 8.0.3 and then running the result on 5.7.18 this happens:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT' at line 1

I think SHOW CREATE USER on 8.0.3 should use: 
/*!800000 HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT */

Instead of:
HISTORY DEFAULT PASSWORD REUSE INTERVAL DEFAULT

How to repeat:
See description

Hello Daniël,

Thank you for the report and feedback!

Thanks,
Umesh