![Antiguo](http://static.forosdelweb.com/fdwtheme/images/statusicon/post_old.gif)
05/05/2010, 10:13
|
![Avatar de huesos52](http://static.forosdelweb.com/customavatars/avatar287966_22.gif) | 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 |