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

2022-01-05 00:00:00 database mysql phpmyadmin

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

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

相关文章