mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
来源:互联网 发布:mysql 登录失败锁定 编辑:程序博客网 时间:2024/06/06 02:49
数据库重装提示没办法保存。提示The user specified as a definer ('root'@'%') does not exist
此时只要给权限就可以了。如下操作:
权限问题,授权 给 root 所有sql 权限
mysql> grant all privileges on *.* to root@"%" identified by ".";
Query OK, 0 rows affected (0.00 sec);
或者用navicat 执行上面语句也可以。
0 0
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- 转载:如何理解jsp页面中的“<base href="<%=basePath%>">”?
- configure: error: Neither flex nor lex was found.
- 新路程------无法从ubuntu虚拟机copy文件
- 27. Remove Element
- Hive--DML
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- 脚本实现文本文件在Linux、mac与window下的正常显示
- 基于ACRGIS二次开发实现地物中心坐标点批量提取
- ListView的简单总结
- python UnicodeEncodeError: 'ascii' codec can't encode characters in position 13-14: ordinal not in r
- LTspice introduction
- 高精度模板 大数的基本运算
- jdbc
- 日期格式不符合要求:Unparseable date: "3e8a4d83533744c698216535a65850c0"