Página Inicial > MySQL, wampserver > The function has none of the DETERMINISTIC, NO SQL, or READS SQL DATA

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

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


Source : Logikdev

Tags: ,
  1. Ainda sem nenhum comentário.
  1. Ainda sem nenhum trackback.