ERROR 1231 (42000): Variable ‘sql_mode’ can’t be set to the value of ‘NO_AUTO_CREATE_USER’

ERROR 1231 (42000) at line 351: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

MacOS

sed -i old 's/\DEFINER=[^]*@[^]*//g' file_name.sql
sed 's/,NO_AUTO_CREATE_USER//g' -i file_name.sql

Linux

sed 's/\sDEFINER=[^]*@[^]*//g' -i file_name.sql
sed 's/,NO_AUTO_CREATE_USER//g' -i file_name.sql

MySQL

SET GLOBAL log_bin_trust_function_creators = 1;