Problem Upgrading MySQL 5.7 to 8.0

0

Hi!

I tried to migrate my MySQL instances but the problem is stored procedure "mysql.flush_rewrite_rules" in mysql database. I tried to remove it but I can't do that. Does anyone have any solution to that?

This is the result of util.checkForServerUpgrade();

  1. MySQL 8.0 syntax check for routine-like objects The following objects did not pass a syntax check with the latest MySQL 8.0 grammar. A common reason is that they reference names that conflict with new reserved keywords. You must update these routine definitions and quote any such references before upgrading. More information: https://dev.mysql.com/doc/refman/en/keywords.html

mysql.flush_rewrite_rules - at line 5,8: unexpected token 'QUERY'

Regards, Gorazd

asked 2 months ago262 views
1 Answer
1

It seems like same issue was reported before. I hope the below URL will help with you.

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

AWS
EXPERT
hyp
answered 2 months ago
  • I know but I would like to know how to solve this. I'm on basic level of support so I can't open technical ticket. Does this mean I need to pay for support to be on another support level so they resolve the problem that I'm not able to solve because I don't have privilege to modify their database.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions