关于definer('root'@'%') does not exit解决办法
来源:互联网 发布:编写javascript的软件 编辑:程序博客网 时间:2024/05/24 02:47
今天把公司的项目拷到自己的电脑运行,结果就出现了这个问题
the user specified as a definer('root'@'%') does not exit
这个问题是权限问题
具体解决步骤如下:
(1)打开DOS窗口,切换到mysql的bin目录下
(2)运行下面的命令进入mysql mysql -u root -proot 我本机用户名和密码都是root -p后是密码
(3) 接下来运行下面的命令:grant all privileges on *.* to root@"%" identified by ".";
接着重新部署项目就行了,运行OK
1 0
- 关于definer('root'@'%') does not exit解决办法
- the user specified as a definer('root'@'%') does not exit解决办法
- definer('root'@'%') does not exist
- a definer ('root'@'%') does not exist
- 如何处理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 apecified a definer('space'@' %')does not exit
- 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 ('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
- 【数据结构栈应用系列】括号匹配
- 【LeetCode】19. Remove Nth Node From End of List
- 杭电 1005 幸福指数
- 集合Map
- storm启动supervisor源码分析-supervisor.clj
- 关于definer('root'@'%') does not exit解决办法
- 1011 of greedy strategy
- UNIX时间戳
- 1010: C语言程序设计教程(第三版)课后习题5.8
- PAT (Advanced Level) Practise 1109 Group Photo (25)
- ListView和Adapter
- 有个@aspect配置在Java控制台下运行良好,tomcat下aop失败
- BZOJ3651网络通信
- worker启动executor源码分析-executor.clj