Symptoms
When transferring a MySQL database from a remote server via the Transfer Tool, this error appears in the transfer log when restoring the database:
The MySQL server reported an error (This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)) in response to this request
Description
This error appears when a specific non-deterministic function, such as a view or stored procedure, is defined for the database and is not compatible with the Transfer Tool due to incorrect security-definer settings. You can read more about this error here:
DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled
Workaround
Manually drop and recreate the database cleanly, then restore it from a database dump file.