ERROR 1449 (HY000): The user specified as a definer ('root'@'%') does not exist
来源:互联网 发布:war3 for mac 1.24e 编辑:程序博客网 时间:2024/05/22 19:24
公司的电脑一直是用的XP,为了用上VS2012,昨天重装了系统,win7好像比XP要快多了呀!
最近一直在调压力测试,今天把服务器上的数据库备份还原到我本地,创建测试账号的时候,突然爆了这个错误:ERROR 1449 (HY000): The user specified as a definer ('root'@'%') does not exist;
这个问题以前也遇到过,应该是账号授权的问题,所以上网搜了一下,果然如此,执行一条sql语句就行了,授权给root 所有host 权限,sql如下:
mysql> grant all privileges on *.* to root@"%" identified by ".";
Query OK, 0 rows affected (0.00 sec)
然后再执行创建测试账号的语句,果然成功了!
- 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
- 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
- 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
- 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
- 如何用二进制表示一个小数
- Linux 共享库: LD_LIBRARY_PATH 与ld.so.conf
- QVariant类学习
- iOS学习之WebView的使用 (主要是下面的全屏半透明实现)
- dockpanelsuite的git
- ERROR 1449 (HY000): The user specified as a definer ('root'@'%') does not exist
- HTML5画布kineticjs灰度图像教程
- 用例规约的编写--业务规则和实体描述
- 设置前台用户登录过期时间
- HTML5画布kineticjs倒像
- Android下拉刷新实例----读取sdcard文件
- 出差,医院自焚,珍爱生命,"右玉精神",出租车,多任务处理器
- A puma at large
- wsprintf使用过程中的问题