![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
zhouzhiyu0622
这个作者很懒,什么都没留下…
展开
-
mysql报错:can be executed in a non-transactional context only
解决mysql报错:java.sql.SQLException: When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can be executed in a non-transactional context only, and require that AUTOCOMMIT = 1.原创 2022-08-29 16:52:03 · 556 阅读 · 0 评论 -
mysql还原备份库报错:MySQL server has gone away
报错信息:[Msg] 2006 - MySQL server has gone away原因分析: 一般原因为sql操作的时间过长,或传送的数据过大。默认配置为4M,考虑备份库存有大附件应该超过了此值,尝试修改配置解决该问题。解决方法: 调整配置为150M(1024*1024*150)mysql> show global variables like 'max_allowed_packet';+----------...原创 2022-02-16 16:51:50 · 628 阅读 · 0 评论 -
mysql还原备份库报错:The user specified as a definer (‘root‘@‘%‘) does not exist
报错信息:The user specified as a definer ('root'@'%') does not exist解决方法:操作:进入mysql安装的bin目录,shift+鼠标右键:登录mysql:mysql -h localhost -u root -p回车-h:服务器名,localhost表示本地;-u:数据库用户名,root为mysql默认用户名;-p:数据库密码,若设置了密码,则输入密码,若未设置密码,直接回车即可。如下登...原创 2022-02-16 16:52:31 · 632 阅读 · 0 评论 -
mysql还原备份库函数报错:This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration
报错信息: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)解决方法:set global log_bin_trust_function_creators原创 2022-02-16 14:47:09 · 567 阅读 · 0 评论