数据库中查不到这条语句：select * from category order by category asc

Question

{"code":-1,"msg":"ER_NO_SUCH_USER: The user specified as a definer ('root'@'%') does not exist","error":500,"errorMsg":"Internal Server Error"}

是不是缺少一个分类的表

Answer 1

扬_灵 2020-04-20 11:42:37

同学你好，这个是因为数据库中没有权限访问视图文件导致的

• 慕沐3184498 #1

  导入视图后无法打开和查询视图，请问怎么改权限？