mysql不能导入和创建存储过程和触发器的解决

我在mysql中很少使用存储过程和触发器，最近公司使用mysql 5.5发现不能导入触发器。

mysql> show global variables WHERE Variable_name LIKE 'log_bin%'; 
+---------------------------------+-------+ 
| Variable_name                   | Value | 
+---------------------------------+-------+ 
| log_bin                         | ON    | 
| log_bin_trust_function_creators | OFF   | 
| log_bin_trust_routine_creators  | OFF   | 
+---------------------------------+-------+ 
3 rows in set (0.00 sec) 


mysql> SET GLOBAL log_bin_trust_function_creators = 1; 
Query OK, 0 rows affected (0.00 sec) 

mysql> SET GLOBAL log_bin_trust_routine_creators = 1; 
Query OK, 0 rows affected, 1 warning (0.00 sec 


mysql> show global variables WHERE Variable_name LIKE 'log_bin%'; 
+---------------------------------+-------+ 
| Variable_name                   | Value | 
+---------------------------------+-------+ 
| log_bin                         | ON    | 
| log_bin_trust_function_creators | ON    | 
| log_bin_trust_routine_creators  | ON    | 
+---------------------------------+-------+ 
3 rows in set (0.00 sec)


如果重启mysql 建议在my.cnf中加入
log-bin-trust-function-creators = true 
log-bin-trust-routine-creators = true