ERROR 1449 (HY000): The user specified as a definer ('skip-grants user'@'skip-grants host') does not exist

导入sql文件时报错:

ERROR 1449 (HY000): The user specified as a definer ('skip-grants user'@'skip-grants host') does not exist

解决方式如下(红色字体即为上述括号里的内容)

mysql> grant all privileges on *.* to 'skip-grants user'@'skip-grants host' identified by ".";

再次执行source,导入sql文件,不再报错。

结束。

posted @ 2020-11-11 14:30  巴州夜雨  阅读(2564)  评论(0编辑  收藏  举报