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