ErrorCode : 1449 The user specified as a definer ('sxyU'@'localhost') does not exist
来源:互联网 发布:简单代码js 上传图片 编辑:程序博客网 时间:2024/06/04 23:25
动态统计数据库表记录---存储过程--脚本的调试过程遇到的问题处理:
对于动态统计数据库表记录---存储过程--脚本 在本地测试通过,但是在远程192.168.21.64linux 环境下,调试遇到如下报错问题:
ErrorCode : 1449
The user specified as a definer ('sxyU'@'localhost') does not exist
解决办法如下:
在mysql数据库里面创建'sxyU'用户:
GRANTALL PRIVILEGES ON *.* TO 'sxyU'@'localhost' IDENTIFIED BY 'root@centos'
FLUSHPRIVILEGES;
然后再调用该存储过程,即发现调试通过并执行。
至于为什么必须创建该用户,还带进一步的研究。
- ErrorCode : 1449 The user specified as a definer ('sxyU'@'localhost') does not exist
- [Err] 1449 - The user specified as a definer ('admin_isbox'@'localhost') does not exist
- Unable to post the review. &&The user specified as a definer ('admin'@'localhost') 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
- 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 ('XXXXX'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('monitor'@'%') does not exist
- The user specified as a definer (''@'') does not exist
- The user specified as a definer ('montor'@'%') does not exist
- The user specified as a definer ('test'@'%') 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 ('lingshi'@'%') does NOT exist
- android 如何在状态栏上增加一个icon
- xargs--命令行输入参数
- 网络安全策略:五大技能让无线网络更安全
- Hibernate Criterion
- 使用C#和Excel进行报表开发(七)-设置单元格的显示格式
- ErrorCode : 1449 The user specified as a definer ('sxyU'@'localhost') does not exist
- Eclipse里调试部署程序、启动Tomcat时报错:SetPropertiesRule
- 黑马程序员 -- 多线程
- android 如何实现:当开启图案解锁时,取消滑动解锁
- linux vi 操作笔记
- android 如何更换屏幕上锁界面背景图片
- jquery特效
- 通用数据权限管理系统设计
- android 如何添加一种锁屏方式