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

gefragt vor 2 Monaten395 Aufrufe
1 Antwort
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
EXPERTE
hyp
beantwortet vor 2 Monaten
  • 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.

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen