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

[8 Dec 2017 11:47] Daniël van Eeden
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
[8 Dec 2017 12:23] Umesh Shastry
Hello Daniël,

Thank you for the report and feedback!

Thanks,
Umesh