How do I fix «The user specified as a definer ('<user>'@'%') does not exist»?

MySQL
, , , ,
1 
GRANT ALL ON *.* TO '<user>'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

stackoverflow.com/a/39701619

2

Another solution:

mysqldump <database> > dump.sql
sed -i 's/DEFINER=`<name>`@`<host>`//g' dump.sql
mysql -e "DROP DATABASE <database>; CREATE DATABASE <database>;" && mysql <database> < dump.sql
3

You can check whether an SQL dump contains a DEFINER with the expression:

grep 'DEFINER' dump.sql
4

An universal solution

For a new dump

mysqldump <database> | sed -E 's/DEFINER=`[^`]+`@`[^`]+`//g' > dump.sql

For an existing dump

sed -E -i 's/DEFINER=`[^`]+`@`[^`]+`//g' dump.sql