MySQL error 1449: The user specified as a definer (''@'') does not exist
来源:互联网 发布:网络监控摄像头客户端 编辑:程序博客网 时间:2024/06/05 23:01
问题描述:在从线上扒库到本地的时,创建视图碰到的这样一个问题:
MySQL error 1449: The user specified as a definer (”@”) does not exist
原因:
从一个数据库或服务器导出视图/触发器/过程到另一个创建该对象的用户不再存在时,通常会出现这种情况。
解决方法:
在mysql环境下执行以下脚本,赋予角色全部权限即可。
GRANT ALL ON . TO ”@” IDENTIFIED BY ‘complex-password’;
FLUSH PRIVILEGES;
不过在此操作之前,你要确定是否可以给这个用户全部的权限。
阅读全文
0 0
- MySQL error 1449: The user specified as a definer (''@'') does not exist
- mysql error: The user specified as a definer ('mysqladmin'@'localhost') does not exist
- ERROR 1449 (HY000): The user specified as a definer ('admin_isbox'@'%') does not exist-j解决方案
- ERROR 1449 (HY000): The user specified as a definer ('db'@'%') does not exist
- ERROR 1449 (HY000): The user specified as a definer ('root'@'%') does not exist
- ERROR 1449 (HY000): The user specified as a definer ('root'@'%') does not exist
- Got error: 1449: The user specified as a definer ('root'@'%') does not exist
- Got error: 1449: The user specified as a definer ('root'@'%') does not exist
- Got error: 1449: The user specified as a definer ('root'@'%') does not exist
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('test01'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- 源代码加密程序:.NET Reactor使用教程
- 吃妖怪的萝莉和帅气道长大叔,古风治愈漫画温暖来袭!
- Java程序如何生成Jar、exe及安装文件
- 使用Eclipse搭建Maven项目(最近做个人网站,顺便记下来以防后面的项目要用)
- kafka新手安装
- MySQL error 1449: The user specified as a definer (''@'') does not exist
- Drawing Contexts(绘图上下文)
- 使用Vue.js搭建简单的表格页面
- Linux命令-parted命令
- 详谈室内定位技术方案
- Java多线程机制
- linux 任务被stuck 或者hung住
- Memcached 入门学习二(命令操作)
- 如何编写一个简单的shell脚本.task3用到的脚本