The user specified as a definer ('root'@'%') does not exist。
来源:互联网 发布:神龙烈焰手办淘宝上买 编辑:程序博客网 时间:2024/04/28 22:04
在使用mysql视图是出现问题: The user specified as a definer ('root'@'%') does not exist。
一般是由于root用户对全局host无访问权限。因此只要给root用户添加一个访问权限即可。
解决办法:
登陆mysql ,执行
mysql -u root -pPasswd
mysql >grant all privileges on *.* to root@"%" identified by "Passwd"
mysql >flush privileges
- 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
- 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 (@'''') does not exist
- The user specified as a definer ('XXXXX'@'%') does not exist
- The user specified as a definer ('monitor'@'%') does not exist
- The user specified as a definer (''@'') does not exist
- 二维数组及其指针基础
- 类型的定义与申明
- 黑马程序员-----学习日记<2>------基础总结1
- MAC系统压缩文件传到WINDOWS下出现乱码
- Big Data
- The user specified as a definer ('root'@'%') does not exist。
- hadoop mr的数据流程交互简单描述
- 【iOS-cocos2d-X 游戏开发之五】游戏存储之Cocos2dX自带CCUserDefault类详解;
- 如何高效的利用dbus做client-server架构
- 匈牙利算法详解
- 剖析Disruptor:为什么会这么快?(一)锁的缺点
- Silverlight path简单使用
- Unable to build: the file dx.jar was not loaded from the SDK folder! 问题的缺失文件
- Linux C下的EOF文件结束符