Error Upgrading MySQL 5.7 to 8.0

Hi,

Look at this similar issue: https://bugs.mysql.com/bug.php?id=112067

It states: the query cache is removed in MySQL 8.0. The command to reset query cache was also removed from the query rewrite script in 8.0. as follows

It is confirmed by MySQL official documentation: https://dev.mysql.com/blog-archive/mysql-8-0-retiring-support-for-the-query-cache/

With the current limitations noted, the query cache will continue to be supported for the life time of MySQL 5.7. MySQL 8.0 will not support query cache, and users upgrading will be encouraged to use either Server-side Query Rewrite or ProxySQL as a man-in-the-middle cache.

So, follow MySQL guidance to fix your issue.

Best,

Didier