he user specified as a definer ('admin_isbox'@'localhost') does not exist
来源:互联网 发布:母婴cms 编辑:程序博客网 时间:2024/06/11 01:49
今天在家里用本地数据库开发的时,报这个错
解决办法:
凭借以前经常见到的root@localhost报错,给root赋值所有权限:
grant all privileges on *.* to root@"%" identified by ".";
flush privileges;
发现无效。
可能数据库没有此用户:
select user,host from mysql.user;
没找到此用户,但是报错出现了这个用户。寻求谷歌后,找到解决方法:
SELECT definer,type FROM mysql.proc GROUP BY definer,type;
UPDATE mysql.proc SET definer='root@localhost' WHERE definer = '*username*@localhost';
重启数据库,OK
2选一 0 0
- he user specified as a definer ('admin_isbox'@'localhost') does not exist
- [Err] 1449 - The user specified as a definer ('admin_isbox'@'localhost') does not exist
- ERROR 1449 (HY000): The user specified as a definer ('admin_isbox'@'%') does not exist-j解决方案
- ErrorCode : 1449 The user specified as a definer ('sxyU'@'localhost') does not exist
- Unable to post the review. &&The user specified as a definer ('admin'@'localhost') does not exist
- mysql error: The user specified as a definer ('mysqladmin'@'localhost') does not exist
- 报错500:The user specified as a definer ('***'@'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
- #HY000The 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
- App上线流程全攻略(史上最详细步骤)
- 有关微信公众平台和html5的想法
- 函数——Swift学习笔记(九)
- sqlconnection、sqldataadapter、sqlcomandbuilder 组合去update,更新数据库?
- JAVA Test之冒泡排序法
- he user specified as a definer ('admin_isbox'@'localhost') does not exist
- 我的Mac OS X使用问题
- tip
- 【OpenCV入门教程之十八】OpenCV仿射变换 & SURF特征点描述合辑
- <meta>标签之viewport
- HDU 2871 Memory Control 线段树
- Windows7 (64位)系统下安装Scrapy详细教程
- android 视频通话 项目 源码
- test