Mysql 安装记录_[my-000067] [server] unknown variable 'query-cache

MYSQL安装记录

2019-07-11T01:13:58.033868Z 0 [System] [MY-013169] [Server] C:\web\mysql-8.0.16-winx64\bin\mysqld.exe (mysqld 8.0.16) initializing of server in progress as process 5992
2019-07-11T01:13:58.045747Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2019-07-11T01:14:01.948380Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default-character-set=utf8'.
2019-07-11T01:14:01.948393Z 0 [ERROR] [MY-013236] [Server] Newly created data directory C:\web\mysql-8.0.16-winx64\data\ is unusable. You can safely remove it.
2019-07-11T01:14:01.971481Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-07-11T01:14:03.393355Z 0 [System] [MY-010910] [Server] C:\web\mysql-8.0.16-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.16)  MySQL Community Server -GPL.
1
2
3
4
5
6

解决：

MYSQL5.5之后修改了字符集，将default-character-set=utf8改为–character-set-server

我的配置文件如下

[mysqld]

[mysqld]
port = 3306
basedir=C:\\web\\mysql-8.0.16-winx64

max_connections=20

character-set-server=utf8

default-storage-engine=INNODB
1
2
3
4
5
6
7
8
9
10
11

navicat连接报错Authentication plugin 'caching_sha2_password’can not be reload

原因：

navicat 不支持

alter user 'root'@'localhost' identified with mysql_native_password by '123456'
1

设置新密码

即可连接