MySQL-8.0.13修改sql_mode后无法进入数据库,重装都不管用

MySQL-8.0.13修改sql_mode后重装都无法进入数据库
我使用的mysql-8.0.13-winx64版本的数据库,我在使用分组查询时候遇到了问题,
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre
然后就按照网上说的修改了sql_mode,也就是把ONLY_FULL_GROUP_BY这个去掉了,之后关闭了CMD窗口再进入就进不去数据库了。然后我把所有的删除然后重装了还是进不去,应该怎么办啊?
在这里插入图片描述

C:\WINDOWS\system32>mysqld install
The service already exists!
The current server installed: D:\mySql\mysql-8.0.13-winx64\bin\mysqld MySQL

C:\WINDOWS\system32>mysql u root -p
mysql Ver 8.0.13 for Win64 on x86_64 (MySQL Community Server - GPL)
Copyright © 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Usage: mysql [OPTIONS] [database]
-?, --help Display this help and exit.
-I, --help Synonym for -?
–auto-rehash Enable automatic rehashing. One doesn’t need to use
‘rehash’ to get table and field completion, but startup
and reconnecting may take a longer time. Disable with
–disable-auto-rehash.
(Defaults to on; use --skip-auto-rehash to disable.)
-A, --no-auto-rehash
No automatic rehashing. One has to use ‘rehash’ to get
table and field completion. This gives a quicker start of
mysql and disables rehashing on reconnect.
–auto-vertical-output
Automatically switch to vertical output mode if the
result is wider than the terminal width.
-B, --batch Don’t use history file. Disable interactive behavior.
(Enables --silent.)
–bind-address=name IP address to bind to.
–binary-as-hex Print binary data as hex
–character-sets-dir=name
Directory for character set files.
–column-type-info Display column type information.
-c, --comments Preserve comments. Send comments to the server. The
default is --skip-comments (discard comments), enable
with --comments.
-C, --compress Use compression in serve

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 5
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 5
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值