Mysql错误:尝试转储表空间时，指定为定义者的用户('mysql.infoschema'@'localhost')不存在' [英] Mysql Error:The user specified as a definer ('mysql.infoschema'@'localhost') does not exist' when trying to dump tablespaces

问题描述

在我将MySQL 5.7升级到MySQL 8.0之后，我再次启动MySQL并收到错误消息:尝试转储表空间时，指定为定义者的用户('mysql.infoschema'@'localhost')不存在. 我不明白为什么会发生此问题.我想知道如何解决

After I upgraded MySQL 5.7 to MySQL 8.0, I started MySQL again and I got an error:The user specified as a definer ('mysql.infoschema'@'localhost') does not exist' when trying to dump tablespaces. I don't understand why this problem occurs. And I want to know how to solve it

推荐答案

当我不小心将MySQL版本从8降级到5.7时，我遇到了同样的错误.第一次启动时，较旧的版本出现了问题，因此版本8显示了上面的错误. 就我而言，我必须进入MySQL首先运行的docker容器

I had the same error when I accidentally downgraded my MySQL version from 8 to 5.7. At the first start the older version broke something so that version 8 was showing the error above. In my case I had to enter the docker container where MySQL was running first

docker exec -it mysql bash

然后，我基本上按照步骤此处

Then I basically followed the steps here

mysql -u root -p
mysql> SET GLOBAL innodb_fast_shutdown = 1;
mysql_upgrade -u root -p

这花了几分钟，但随后一切又恢复正常了.

This took some minutes but then everything was working again.

这篇关于Mysql错误:尝试转储表空间时，指定为定义者的用户('mysql.infoschema'@'localhost')不存在'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！