mysql 建立函数时报错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> show variables like 'log_bin_trust_function_creators';
+————————————–+——-+
| Variable_name | Value |
+————————————–+——-+
| log_bin_trust_function_creators | OFF |
+————————————–+——-+
更改
mysql> set global log_bin_trust_function_creators=1;
mysql> show variables like 'log_bin_trust_function_creators';
+———————————+——-+
| Variable_name | Value |
+———————————+——-+
| log_bin_trust_function_creators | ON |
+———————————+——-+
mysql 重启 配置会失效,永久生效在my.cnf配置文件中添加
log_bin_trust_function_creators=1
-bash: mysql: command not found
[root@DB-02 ~]# mysql -u root
报错 -bash: mysql: command not found
原因:这是由于系统默认会查找/usr/bin下的命令,如果这个命令不在这个目录下,当然会找不到命令,我们需要做的就是映射一个链接到/usr/bin目录下,相当于建立一个链接文件。
比如mysql的路径是:/usr/local/mysql/bin/mysql,执行
# ln -s /usr/local/mysql/bin/mysql /usr/bin