mysql 存储过程的权限问题 java.sql.SQLException: The user specified as a definer ('xxxx'@'%') does not exist
来源:互联网 发布:二进制是谁发明的 知乎 编辑:程序博客网 时间:2024/03/29 07:47
从一个数据库 复制存储过程到另外一个数据库
如果是用图形界面的软件 比方说navicat 复制过去的话,然后执行 容易报错如下
java.sql.SQLException: The user specified as a definer ('xxxx'@'%') does not exist
因为在创建存储过程的时候吧相应的 定义的权限也带过去了,修正办法如下
重新定义存储过程了,比方说增加
create definer ='root@localhost' procedure()
当然你也可以选择重新创建,不过重新创建以后也有可能出现 上面的额错误 ,就只能
UPDATE`mysql`.`proc` p SET definer ='root@localhost'WHERE definer='root@foobar'
0 0
- mysql 存储过程的权限问题 java.sql.SQLException: The user specified as a definer ('xxxx'@'%') does not exist
- Mysql java.sql.SQLException: The user specified as a definer ('ht_release'@'%') does not exist
- java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist
- Caused by: java.sql.SQLException: The user specified as a definer ('eln'@'%') does not exist
- ### Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist
- java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist 解决方法
- Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist
- java.sql.SQLException: The user specified as a definer ('myroot'@'%') does not exist
- java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist 解决方法
- 关于mysql存储过程报错The user specified as a definer ('oem'@'%') does not exist
- mysql权限问题_mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- The user specified as a definer (''@'%') does not exist问题
- mySql问题:The user specified as a definer ('root'@'%') does not exist 解决方法
- MYSQL操作中错误The user specified as a definer ('root'@'%') does not exist的解决
- MYSQL操作中错误The user specified as a definer ('root'@'%') does not exist的解决
- The user specified as a definer (@'''') does not exist
- The user specified as a definer ('root'@'%') does not exist。
- The user specified as a definer ('root'@'%') does not exist
- 基于huffman压缩的课程设计
- Hadoop异常合集(更新中~)
- 《HTTP权威指南》——认证机制
- First Blog
- hdu 5162(概率期望)
- mysql 存储过程的权限问题 java.sql.SQLException: The user specified as a definer ('xxxx'@'%') does not exist
- block引用外部变量(三)
- 学习计划
- 欢迎使用CSDN-markdown编辑器
- Android的一些基本常识
- Android齐步走-2(2016-7-1)
- 爬虫:HTTP请求和requests库
- vs配置信息问题
- ubuntu16.10上的ROS Kinetic和ubuntu14.04上的ROS Jade的通讯设置