Several error messages may display during migration to a MySQL server when binary logging is enabled.
The first message displays during index creation.
A second message displays during data copy.
MySQL 5.0.16 introduced requirements that when binary logging is enabled, you must have the SUPER privilege and a function must be declared DETERMINISTIC if you are using statement-based (the default) binary-logging.
Binary logging is enabled in MySQL by adding these lines to the my.ini file:
#*** Binlog Settings
# Binary Log Options and Variables (Replication)
#Binary Log Options and Variables
To resolve this problem, add these two lines to the [mysqld] section of the my.ini file:
This changes how MySQL enforces restrictions on stored function and trigger creation and changes the log format to use row-based logging.