创建算法=未定义的定义器

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.....

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