报错500:The user specified as a definer ('***'@'localhost') does not exist解决方法
来源:互联网 发布:淘宝onlyanna老公小苏 编辑:程序博客网 时间:2024/06/05 00:09
从一个数据库数据迁移到本地localhost
打开网页后报错500:The user specified as a definer ('****'@'localhost') does not exist。
解决方法:
1.在cmd中打开MySQL
2.权限问题,授权 给 root 所有sql 权限
mysql> grant all privileges on *.* to ***@"localhost" identified by ".";
.
3.再次打开浏览器,打开该网页,就OK了。
阅读全文
0 0
- 报错500:The user specified as a definer ('***'@'localhost') does not exist解决方法
- 数据库报错The user specified as a definer ('root'@'%') does not exist 解决方法
- mysql出现The user specified as a definer ('root'@'%') does not exist报错!
- 关于mysql存储过程报错The user specified as a definer ('oem'@'%') does not exist
- mysql出现The user specified as a definer ('root'@'%') does not exist报错!
- Unable to post the review. &&The user specified as a definer ('admin'@'localhost') does not exist
- 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
- JAVA-ACE-架构师系列视频课程- RocketMQ(上)
- JNI DETECTED ERROR IN APPLICATION 解决记录
- CSS display 属性详解
- Centos下用inotify+rsync实现自动同步功能
- 超人学院大数据第8期高薪就业培训
- 报错500:The user specified as a definer ('***'@'localhost') does not exist解决方法
- 屏幕适配心得
- django-rest-framework 简写为-drf
- Day12—Object类、包装类、数学处理类、String类
- 设计模式-单例模式(单元素模式)
- gradle插件升级
- 《Flask Web开发》读书笔记(6)第6章电子邮件(关键词:Web开发/Flask/电子邮件)
- 中企动力携手河南卫特解锁网络营销新模式
- servlt -异步处理