RDS Upgrade Fails! from mysql 5.7 to mysql 8.0

You may want to read this: https://repost.aws/knowledge-center/rds-mysql-preupgrade-failure

Hello AWS Customer,

If you experience a preupgrade check failure during version upgrade, review the PrePatchCompatibility log file that Amazon RDS generates.

You can view the PrePatchCompatibility log file under Logs & events in the Amazon RDS console. Then, review the details of the listed incompatibility issue and correct the issue. In most cases, the log entry includes a link to the Amazon RDS for MySQL documentation on how to correct the incompatibility.

Please go through the below references for more details.

• [+] https://repost.aws/knowledge-center/rds-mysql-preupgrade-failure
• [+] https://dev.mysql.com/blog-archive/upgrading-to-mysql-8-0-here-is-what-you-need-to-know/

If you still not able to upgrade after reviewing and making the required changes as per the PrePatchCompatibility log file, please do reach out to AWS Support via a support case and we will assist you further.

I hope the above information was helpful to you.

Have a great day ahead !!