mysql show

[doramon]

mysql> set global log_bin_trust_routine_creators=1;


mysql> show variables like 'log_bin%';

[nph2006]

มีประโยชย์ อะไรครับ อ.อ๊อด

[มดตานอย ครับ..]

mysql> set global log_bin_trust_routine_creators=1;


mysql> show variables like 'log_bin%';

มีประโยชย์ อะไรครับ อ.อ๊อด

[กรรมคือการกระทำ]

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 and SUPER is not required for function creation.

ปกติ จะเป็น  0

หรือจะทำไว้ที่ My.cnf ก็ได้ครับ

http://mysql-dox.net/O.Reilly-MySQL.Stored.Procedur/0596100892/mysqlspp-CHP-10-SECT-1.html

[asawincyber]

mysql> set global log_bin_trust_routine_creators=1;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show variables like 'log_bin%';
+---------------------------------------+-------+
| Variable_name                            | Value |
+---------------------------------------+-------+
| log_bin                                       | OFF   |
| log_bin_trust_function_creators | ON    |
| log_bin_trust_routine_creators   | ON    |
+----------------------------------------+-------+
3 rows in set (0.02 sec)
  ถูกต้องไหมครับ