mysql
分享一些在学习mysql过程中遇到的问题
dududu名字不重复
这个作者很懒,什么都没留下…
展开
-
错误:This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in...的解决方法
描述:我们在mysql中创建或调用储存函数时可能会抛出错误:This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled(you *might* to use the less safe log_bin_trust_function_creators variables)原因:这其实是创建的储存函数不被二进制日志文件信任导致的。解决办法原创 2020-11-19 23:38:02 · 442 阅读 · 0 评论 -
The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not exist.异常的解决
The user specified as a definer (‘mysql.infoschema’@‘localhost’) does not exist.异常的解决问题描述1.使用Navicat连接MySQL数据库时抛出异常The user specified as a definer (‘mysql.infoschema’@‘localhost’) does not exist.2.检测连接发现连接正常。解决过程根据网友方案进行操作:1.进入dos窗口;2.输入mysql -uroo原创 2020-11-04 16:31:28 · 1513 阅读 · 0 评论