错误代码: 1449 The user specified as a definer ('root'@'%') does not exist
来源:互联网 发布:100元以内耳机知乎 编辑:程序博客网 时间:2024/05/18 22:46
1. 错误描述
1 queries executed, 0 success, 1 errors, 0 warnings查询:call analyse_use('20150501','20150601')错误代码: 1449The user specified as a definer ('root'@'%') does not exist执行耗时 : 0 sec传送时间 : 0 sec总耗时 : 0.003 sec
2. 错误原因
在存储过程里,我用的用户是root,而实际的是skyusers
3. 解决办法
将以下代码
CREATE DEFINER=`localhost`@`%` PROCEDURE `analyse_use`(IN `startDate` VARCHAR(20),IN `endDate` VARCHAR(20))
修改成
CREATE DEFINER=`skyusers`@`%` PROCEDURE `analyse_use`(IN `startDate` VARCHAR(20),IN `endDate` VARCHAR(20))
1 0
- 错误代码: 1449 The user specified as a definer ('root'@'%') does not exist
- 错误代码: 1449 The user specified as a definer ('root'@'%') does not exist
- mysql错误代码: 1449 The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist。
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist。 .
- The user specified as a definer ('root'@'%') does not exist。
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- #1449 - The user specified as a definer ('root'@'%') does not exist
- ERROR 1449 (HY000): The user specified as a definer ('root'@'%') does not exist
- 10个大坑,当你产品上架AppStore会遇到
- 浏览图片
- 水平进度条ProgressBar
- 每个Linux用户都应该知道的命令行技巧
- 2012年5月SAT香港真题解析
- 错误代码: 1449 The user specified as a definer ('root'@'%') does not exist
- C语言排序:冒泡排序
- ASO优化经验:APP关键字优化的技巧
- GUI编程及文件对话框的使用
- 2012年5月SAT香港真题解析
- undefied
- SwipeRefreshLayout 下拉刷新、加载更多、分页索引功能
- 为什么我编程的速度越来越慢了
- iOS App提交指南-协议、税务和银行业务