MySQL错误:The user specified as a definer (XXX@XXX) does not exist
程序员文章站
2022-03-02 18:35:19
...
使用HeidiSQL从Linux导出MySQL数据库,然后恢复到本地(Windows)
但是连数据库进行查询时报异常:
The user specified as a definer ('db_chf'@'xxxxx' ) does not exist
意思是某个数据库对象的定义者(也就是'db_chf'@'xxxxx' )不存在
后来终于找到了原因,原来是导出并恢复数据库时,视图的定义者还是原来的用户:'db_chf'@'xxxxx' ,
但是本地数据库并没有db_chf这个用户,只有root用户,所以只要将视图的定义者修改为root即可解决问题。
上一篇: 移动WebApp开发 JS框架对比
下一篇: 移动WebApp开发 JS框架对比
推荐阅读
-
mysql的“The user specified as a definer (”@’%') does not exist”问题 解决
-
MySqlException: The user specified as a definer ('root'@'%') does not exist解决方法
-
The user specified as a definer ('root'@'%') does not exist 博客分类: mysql
-
The user specified as a definer ('root'@'%') does not exist
-
mysql 1449:The user specified as a definer ('root'@'%') does not exist 报错解决方法
-
magento2 迁移服务器后,修改后台The user specified as a definer (‘*****‘@‘%‘) does not exist
-
mysql的“The user specified as a definer (”@’%') does not exist”问题 解决
-
MySQL 脚本报错:The user specified as a definer (‘skip-grants user‘@‘skip-grants host‘) does not exist
-
MySqlException: The user specified as a definer ('root'@'%') does not exist解决方法
-
mysql 1449:The user specified as a definer ('root'@'%') does not exist 报错解决方法