更新时间:2021-08-28 15:57:13
从您的sqldump文件中删除DEFINER=..
语句,或将用户值替换为CURRENT_USER
.
Either remove the DEFINER=..
statement from your sqldump file, or replace the user values with CURRENT_USER
.
根据我的经验,RDS提供的MySQL服务器不允许其他用户使用DEFINER
语法.
The MySQL server provided by RDS does not allow a DEFINER
syntax for another user (in my experience).
您可以使用sed
脚本将其从文件中删除:
You can use a sed
script to remove them from the file:
sed 's/\sDEFINER=`[^`]*`@`[^`]*`//g' -i oldfile.sql