连接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
欢迎讨论,相互学习。 txwtech@163.com
原文地址:https://www.cnblogs.com/txwtech/p/15430050.html