definer('root'@'%') does not exist
来源:互联网 发布:淘宝代运营销售累不累 编辑:程序博客网 时间:2024/06/03 04:31
项目开发中,经常会遇到数据库的迁移。但是如果迁移过去的数据库,没用之前创建该数据库的用户,在执行视图或者存储过程的时候会报:1449 The user specified as a definer (‘root’@’%’) does not exist。
另外,在实际项目过程中,使用了免安装的mysql,配置好后,用navicat连接本地数据库,也会出现这种问题,碰到的不止一次喽。那么,我们该如何解决呢??
1、打开DOS,将目录切换至mysql的bin目录下
2、登录mysql,输入命令mysql -uroot -p,回车,会提示输入密码,如下
输入密码后,再回车。登录成功
3、添加host访问权限;命令如下:
grant all privileges on . to root@”%” identified by “123456”;
4、最后更新权限;命令如下:flush privileges;
5、再次运行或再次用navicat连接,问题解决了。
阅读全文
0 0
- 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
- #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
- 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 when
- 单例模式(皇后和皇上的故事)
- 面向对象思想小案例——银行存取款代码示例static类属性运用
- 设计模式之简单工厂模式 工厂模式
- rel="stylesheet"
- 如何cmd命令行下直接运行Matlab的M文件
- definer('root'@'%') does not exist
- Android单元测试(单个Activity单元测试,网络请求单元测试,单个类单元测试)在AndroidStudio编写
- Map可根据value的值进行排序
- ssh框架栈溢出异常
- LINK : fatal error LNK1123: 转换到 COFF 期间失败: 文件无效或损坏
- 【STM32F103】DMA学习笔记(陆续添加)
- 微信自动回复功能实现
- Java String与StringBuffer
- 设备环境(Device Context)(设备上下文)