you *might* want to use the less safe log_bin_trust_function_creators variable

报错:you *might* want to use the less safe log_bin_trust_function_creators variable

解决方法如下:

  1. mysql> SET GLOBAL log_bin_trust_function_creators = 1;

  2. 系统启动时 --log-bin-trust-function-creators=1

  3. 在my.ini(linux下为my.conf)文件中 [mysqld] 标记后加一行内容为 log-bin-trust-function-creators

报错:Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes

SET GLOBAL max_allowed_packet = 2*1024*1024*10;

或者在my.cnf中添加配置:

max_allowed_packet = 20M

原文地址:https://www.cnblogs.com/taiguyiba/p/6419766.html