I have a web server that serves Magento2 and a MySQL Server that hosts the database and both of these servers are in a single ubuntu instance.
I would like to move the MySQL server to a separate RDS MySQL instance, so I have dumped the database with mysqldump as root user and while uploading it to RDS MySQL instance I get:
"ERROR 1227 (42000) at line 2873: Access denied; you need (at least one of) the SUPER privilege(s) for this operation"
I have checked for the solution and removed DEFINER with
//g' -i dumpedfile.sql and after removing DEFINER the upload worked without any error.
My question is, what exactly definer is, is it safe to remove it from the dumped file of a Magento 2 database?