Ver Mensaje Individual
  #2 (permalink)  
Antiguo 05/05/2010, 10:13
Avatar de huesos52
huesos52
Colaborador
 
Fecha de Ingreso: febrero-2009
Ubicación: Manizales - Colombia
Mensajes: 5.980
Antigüedad: 15 años, 6 meses
Puntos: 360
Respuesta: Duda con SET GLOBAL log_bin_trust_function_creators = 1;

Cita:
To relax the preceding conditions on function creation (that you must have the SUPER privilege and that a function must be declared deterministic or to not modify data), set the global log_bin_trust_function_creators system variable to 1. By default, this variable has a value of 0, but you can change it like this:

mysql> SET GLOBAL log_bin_trust_function_creators = 1;
You can also set this variable by using the --log-bin-trust-function-creators=1 option when starting the server.

If binary logging is not enabled, log_bin_trust_function_creators does not apply. SUPER is not required for function creation unless, as described previously, the DEFINER value in the function definition requires it.
Tomado de
http://dev.mysql.com/doc/refman/5.0/...s-logging.html

Al momento de iniciar el servidor puedes levantarla y quedará por defecto.

saludos
__________________
Without data, You are another person with an opinion.
W. Edwads Deming