求助各位大佬:
环境:win7,NavicatPremium15,MySQL8.0.19
问题:第一次用Navicat连MySQL,之前都是没用Navicat的。
详细情况:
cmd和Windows PowerShell都能连上,密码和账号也没问题
防火墙已关闭
已经设置blind -address=0.0.0.0
尝试重装了两次服务都没有解决
尝试了MySQL5.7也不行
hosts中也没有屏蔽127.0.0.1
#下面是my.ini中的详细配置:
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8
[mysqld]
skip-grant-tables
#设置3306端口
port = 3306
# 设置mysql的安装目录
basedir=D:\mysql-8.0.19-winx64
# 设置mysql数据库的数据的存放目录
datadir=D:\mysql-8.0.19-winx64\data
# 允许最大连接数
max_connections=1000
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
bind-address = 0.0.0.0
explicit_defaults_for_timestamp=true
shared-memory
skip-grant-tables
#下面是错误日志:
2020-03-05T12:53:26.327502Z 0 [System] [MY-013105] [Server] D:\mysql-8.0.19-winx64\bin\mysqld.exe: Normal shutdown.
2020-03-05T12:53:28.981573Z 0 [System] [MY-010910] [Server] D:\mysql-8.0.19-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.19) MySQL Community Server - GPL.
2020-03-05T12:53:39.108646Z 0 [System] [MY-010116] [Server] D:\mysql-8.0.19-winx64\bin\mysqld.exe (mysqld 8.0.19) starting as process 2916
2020-03-05T12:53:39.267199Z 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.
2020-03-05T12:53:47.114670Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-03-05T12:53:47.324846Z 0 [System] [MY-010931] [Server] D:\mysql-8.0.19-winx64\bin\mysqld.exe: ready for connections. Version: '8.0.19' socket: '' port: 0 MySQL Community Server - GPL.
2020-03-05T12:53:47.591546Z 0 [Warning] [MY-011311] [Server] Plugin mysqlx reported: 'All I/O interfaces are disabled, X Protocol won't be accessible'
各位,知道的帮个忙,谢谢。