mysqldump: Got error: 1449: The user specified as a definer 的解决方案!
来源:互联网 发布:淘宝旺旺上怎么发邮箱 编辑:程序博客网 时间:2024/06/04 20:02
[root@ba ~]# mysqldump --default-character-set=utf8 --databases susite ucme >/home/2db-uch-ss-20120312.sql
mysqldump: Got error: 1449: The user specified as a definer ([url=mailto:]'mbuch'@'10.6.21.%'[/url]) does not exist when using LOCK TABLES
【】建用户
mysql> grant select,insert,update,delete on mchome.* to [url=mailto:]'mbuch'@'10.6.21.%'[/url] identified by 'mbuch';
Query OK, 0 rows affected (0.82 sec)
【】ok成功了
[root@ba ~]# mysqldump --default-character-set=utf8 --databases supesite uchome >/home/2db-uch-ss-20120312.sql
[root@ba ~]# ll
我这个办法比较懒惰,不知道大家有别的比较好的解决方案没有?share下,谢谢!
0 0
- mysqldump: Got error: 1449: The user specified as a definer 的解决方案!
- mysqldump: Got error: 1449: The user specified as a definer 的解决方案!
- 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
- ERROR 1449 (HY000): The user specified as a definer ('admin_isbox'@'%') does not exist-j解决方案
- Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TAB
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方案
- ERROR 1449 (HY000): The user specified as a definer ('db'@'%') 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 ('root'@'%') does not exist
- MySQL error 1449: The user specified as a definer (''@'') does not exist
- yii中使用find之后,save总是报“SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('root'@'%
- yii中使用find之后,save总是报“SQLSTATE[HY000]: General error: 1449 The user specified as a definer (&
- The user specified as a definer ('wx_root'@'%') does not exist 解决方案
- mysql error: The user specified as a definer ('mysqladmin'@'localhost') does not exist
- Error querying database. Cause: java.sql.SQLException: The user specified as a definer (''@'') doe
- mysqldump报错'The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES'
- 欢迎使用CSDN-markdown编辑器
- 同一个字符串,放到文件前后居然不相等
- CSS3实例教程:超炫的网页进度条
- This Android SDK requires Android Developer Toolkit version 23.0.0 or above
- matlab函数整理
- mysqldump: Got error: 1449: The user specified as a definer 的解决方案!
- 练习9: 在windows MFC窗口中用GDI显示BMP图片
- Spring MVC的初次使用
- iOS运行流程
- HTML5学习之FileReader接口
- POJ4048
- 在云上搭建大规模实时数据流处理系统
- 坐标离散化处理
- HDU 1754 I Hate It(简单线段树-单点更新,区间询问)