MySQL数据库开启、关闭、查看函数功能的方法_MySQL
- WBOYOriginal
- 2016-06-01 13:05:291102browse
应用 MySQL 时，会遇到不能创建函数的情况。出现如下错误信息：
代码如下:
ERROR 1418 : This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
那是因为没有将功能开启。
开启MySQL函数功能：
代码如下:
SET GLOBAL log_bin_trust_function_creators=1;
关闭MySQL函数功能：
代码如下:
SET GLOBAL log_bin_trust_function_creators=0;
查看状态：
代码如下:
show variables like '%func%';
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：MySQL5.1主从同步出现Relay log read failure错误解决方法_MySQLNext article：mysql 增加修改字段类型及删除字段类型_MySQL