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

已提問 2 個月前檢視次數 398 次
1 個回答
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
專家
hyp
已回答 2 個月前
  • 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.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南