mysql
coder_No.0
这个作者很懒,什么都没留下…
展开
-
Linux MySQL 5.7二进制 小版本快速升级
配置 mysql 慢速关闭mysql -u root -p --execute="SET GLOBAL innodb_fast_shutdown=0"关闭 mysql 服务mysqladmin -u root -p shutdown备份数据文件mkdir /work/data_bak && cp -r /work/data/* "$_"备份原 mysql 应用文件mv /work/{mysql,mysql_bak}使用新版 mysql 替换原 my..原创 2020-09-28 18:55:18 · 657 阅读 · 0 评论 -
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary log
出错信息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)出错原因开启了bin-log但是创建函数/存储过程时未指定类型解决方法1. 指定函..原创 2020-09-25 09:51:52 · 404 阅读 · 0 评论