search

Home >Database >Mysql Tutorial >log_bin_trust_function_creators错误解决_MySQL

log_bin_trust_function_creators错误解决_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:32:022597browse

bitsCN.com

log_bin_trust_function_creators错误解决

 

当有mysql本地或远程建立function或procedure时报上面的错误 

经试验是log_bin_trust_function_creators值为off导致 

 

设置： 

 

set global log_bin_trust_function_creators=1;

 

 

但重启后失效 

 

永久解决方案 

windows下my.ini[mysqld]加上log_bin_trust_function_creators=1 linux下/etc/my.cnf下my.ini[mysqld]加上log_bin_trust_function_creators=1

 

 

保存 ，重启服务器。

bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql函数实例-统计日新增用户_MySQLNext article：mysql常用数据类型详细说明及实例说明(学习笔记一)_MySQL

Related articles

See more