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文件,不再报错。

结束。

原文地址:https://www.cnblogs.com/liusingbon/p/13958515.html