Arquivo de Fevereiro, 2014

The function has none of the DETERMINISTIC, NO SQL, or READS SQL DATA

9, Fevereiro, 2014 Nenhum comentário

If you got this error:

ERROR 1419 (HY000) at line 1140: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

The error message is pretty clear. Binary logging needs to be enabled in order to restore the functions. There are two ways for doing this:

  • Execute the following command into the MySQL console:
  • Add the line to the mysql.ini configuration file
Tags: ,