创建算法=未定义的定义 [英] CREATE ALGORITHM=UNDEFINED DEFINER

问题描述

我从远程服务器上备份了一些数据库，当我尝试导入该备份时，我在本地服务器上遇到了问题.我在这一行出现错误:

I make a backup of some database from distance server, and I had an problem on my local server when I trying to import that backup. I get an error in this line:

CREATE ALGORITHM=UNDEFINED DEFINER=root@% SQL SECURITY DEFINER VIEW tematics_field AS select.....

两个服务器都有一个mysql 5.5.2x.用户在这两个服务器上是不同的.

Both server have a mysql 5.5.2x. And users are different in that two servers.

推荐答案

您需要将主机名(在这种情况下为通配符)放在单引号中

You need to put the hostname (or wildcard in this case) in single-quotes:

CREATE ALGORITHM=UNDEFINED DEFINER=root@'%' SQL SECURITY DEFINER VIEW tematics_field AS 
select.....

这篇关于创建算法=未定义的定义的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！