Python整合MySQL出现AttributeError: module 'socket' has no attribute 'AF_UNIX'

运行环境

1、pycharm3.6

2、MySQL 8.0.12

首先是按照书本上的操作输入代码（123456为我的密码，按实际填写）

import pymysql
conn = pymysql.connect(host='127.0.0.1', unix_socket='/tmp/mysql.sock',user='root',
                       passwd='123456', db='mysql')
cur = conn.cursor()
cur.execute("USE scraping")

cur.execute("SELECT * FROM pages WHERE id=1")
print(cur.fetchone())
cur.close()
conn.close()

运行结果：

Traceback (most recent call last):
  File "D:/wangyi/MySQL.py", line 3, in <module>
    passwd='123456', db='mysql')
  File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pymysql\__init__.py", line 94, in Connect
    return Connection(*args, **kwargs)
  File "C:\Users\Administrato