Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > log_bin_trust_function_creators错误解决_MySQL

log_bin_trust_function_creators错误解决_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-01 13:32:02
Original
2607 people have browsed it

bitsCN.com

log_bin_trust_function_creators错误解决

 

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

经试验是log_bin_trust_function_creators值为off导致 

 

设置： 

 

set global log_bin_trust_function_creators=1;
Copy after login

但重启后失效

永久解决方案 

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

 

 

保存 ，重启服务器。

bitsCN.com
Related labels：
function mysql procedure
source：php.cn
Previous article：mysql函数实例-统计日新增用户_MySQL Next article：mysql常用数据类型详细说明及实例说明(学习笔记一)_MySQL
Statement of this Website
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
Latest Articles by Author
Latest Issues
Method to call SQL stored procedure: use CreateNativeQuery
From 1970-01-01 08:00:00
0
0
0
linux - mysql stored procedure error reporting when calling
From 1970-01-01 08:00:00
0
0
0
PHP: Call MySQL stored procedure with input and output parameters (not "INOUT")
From 1970-01-01 08:00:00
0
0
0
How to create a MySQL stored procedure from PHP?
From 1970-01-01 08:00:00
0
0
0
Run a stored procedure that populates a temporary table and then selects from the temporary table
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template