![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
antrychme
这个作者很懒,什么都没留下…
展开
-
MySQL导出数据到文件 ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option
在做mysql 大批量导出数据的时候,所遇到的问题如下:ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statementmysql 默认对导出的目录有权限限制,也就是说使用命令行进行导出的时候,需要指定目录进行操...原创 2018-08-15 18:48:46 · 1775 阅读 · 0 评论 -
MySQL创建函数 ERROR 1418 (HY000): This function has none of ETERMINISTIC, NO SQL, or READS SQL DATA
在MySQL中创建函数时发生如下错误: ERROR 1418 (HY000): This function has none of ETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin...原创 2018-08-18 11:57:36 · 1464 阅读 · 1 评论 -
mysql使用group by分组时出现错误ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and
使用mysql,group by分组时出现错误: ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘advanced.dept.deptno’ which is not functionally dependent on c...原创 2018-08-22 23:18:20 · 23505 阅读 · 6 评论 -
MySQL修改密码后无法进入问题ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor)
MySQL之前无密码,使用 UPDATE mysql.user SET authentication_string=’xxxx’ WHERE user=’root’ and host=’localhost’;修改增加密码后登入一直报错, root以及密码确定是正确,却怎么也无法从本地登录MySQL,提示 ERROR 1045 (28000): Access denied for u...原创 2018-08-23 14:30:11 · 7568 阅读 · 0 评论