MySQL
ray_yang0420
这个作者很懒,什么都没留下…
展开
-
Access denied for user ‘‘@‘localhost‘ (using password: NO)
发现错误的时候,我还以为登录mysql的密码不对,结果发现springboot的自动补全坑了我我的数据库配置如下:spring.datasource.driver-class-name=com.mysql.jdbc.Driver#数据的URLspring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC#登录数据库的原创 2020-12-10 16:52:44 · 1040 阅读 · 0 评论 -
连接MySQL数据库报错The server time zone value ‘�й���ʱ��‘ is unrecognized or represemore than one time zone
连接MySQL报了一个时区的错误:The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you原创 2020-11-28 15:27:31 · 371 阅读 · 0 评论 -
Navicat报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clauseand contains nonaggr
刚刚把Navicat安装好,新建了一个测试库,打算键个测试表,执行了建表语句,insert语句,SQL语句都执行了成功了,但是还是报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns i原创 2020-11-27 09:33:57 · 14949 阅读 · 3 评论