Error Upgrading MySQL 5.7 to 8.0 MySQL 8.0 syntax check for routine-like objects

Question

2) MySQL 8.0 syntax check for routine-like objects
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
More Information:
https://dev.mysql.com/doc/refman/en/keywords.html
mysql.flush_rewrite_rules - at line 5,8: unexpected token 'QUERY'

Above is my error message in PrePatchCompatibility file when I upgrade mysql from 5.7 to 8.0. But I can't find where the problem is to fix it. After doing research, I learned that there are people like me and they have to ask AWS support to drop them for them. How can I solve this problem?

Answer

I would recommend you to reach out to AWS Support team,

```
Update: I reached out to AWS Support and they mentioned that the mysql.flush_rewrite_rules procedure had to be dropped by the internal AWS RDS development team. I had them drop the procedure and was able to upgrade the database successfully after that.
```

https://repost.aws/questions/QU_jfgd2gURk6TzL8JcQCO9Q/error-upgrading-mysql-5-7-to-8-0#ANLOZpV0AWQcusXooIc62zEQ

https://repost.aws/questions/QUoE-he7giSgmAnx1qET17EQ/error-when-upgrading-aurora-mysql-from-v2-5-7-to-v3-8-0#ANGukREsy3Q4Kbe5h3qArwqQ

Error Upgrading MySQL 5.7 to 8.0 MySQL 8.0 syntax check for routine-like objects

Relevant content