连接win7的mysql很慢解决方法

打开my.ini，在mysqld下面添加skip-name-resolve，停止mysql服务，再启动。即可

[mysqld]
character-set-server=utf8
bind-address = 0.0.0.0
port = 3306
basedir=D:/mysql-5.7.24-winx64
datadir=D:/MySQL_Data_OQA/data
max_connections=2000
default-storage-engine=INNODB
skip-name-resolve
[mysql]
default-character-set=utf8
[mysql.server]
default-character-set=utf8
[client]
default-character-set=utf8

其它参考方法：

C:WindowsSystem32driversetc，hosts文件，查看是否如下配置。把文件属性-安全-编辑，添加用户权限后，才能修改保存。

# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host

# localhost name resolution is handled within DNS itself.
#    127.0.0.1       localhost
#    ::1             localhost