The user specified as a definer (''@'%') does not exist
来源:互联网 发布:黑色编程界面 编辑:程序博客网 时间:2024/05/20 08:23
项目开发中,经常会遇到数据库的迁移。但是如果迁移过去的数据库,没用之前创建该数据库的用户,在执行视图或者存储过程的时候会报:
The user specified as a definer (''@'%') does not exist
1.打开DOS,将目录切换至mysql的bin目录下:
切换命令示例:cd D:/MySQL/bin
2.登录;命令如下:
D:\MySQL\bin>mysql -u root -p
按回车,然后输入密码,再按回车,登陆成功!
3.添加host访问权限;命令如下:
grant all privileges on *.* to ''@"%" identified by "root";
4.最后更新权限;命令如下:
flush privileges;
上图,前面的比较简单就不展示了,这是最后也是最重要的两部。
注意你的关键字 和 密码:
阅读全文
0 0
- The user specified as a definer (@'''') 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 ('XXXXX'@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer ('monitor'@'%') does not exist
- The user specified as a definer (''@'') does not exist
- The user specified as a definer ('montor'@'%') does not exist
- The user specified as a definer ('test'@'%') 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 ('lingshi'@'%') does NOT exist
- The user specified as a definer ('root'@'%') does not exist
- The user specified as a definer (''@'%') does not exist
- The user specified as a definer ('root'@'%') does not exist
- Text+底部导航+中间凸起图标
- 页面滚动到底部自动加载
- 文件操作(CRT、C++、WIN API、MFC)
- ByteBuffer基本概念
- 关于状压
- The user specified as a definer (''@'%') does not exist
- linux 常用命令学习--主要是blog汇总
- xshell乱码问题解决
- 关于链表的C++文件读写
- [一起学Hive]之十三-Hive整合HBase,操作HBase表
- 关于JavaScript中Get/Set访问器
- Windows 性能监视器概述
- 接口回调
- CPU负载过高