windows - 用python3的pymysql库连接mysql时出现AttributeError

Question

刚开始学用python整合mysql，代码如下

import pymysql

conn = pymysql.connect(host='127.0.0.1',unix_socket='/tmp/mysql.sock',user='zzp',password='zaqwsx123',db='mysql')
cur = conn.cursor()
cur.execute('USE scraping')
cur.execute('SELECT * FORM pages WHERE id = 1')
print(cur.fetchone())
cur.close()
conn.close()

• 运行时就出错了：

  Traceback (most recent call last):
  File "C:/Users/zzp/PycharmProjects/untitled2/test.py", line 3, in <module>
  conn = pymysql.connect(host='127.0.0.1',unix_socket='/tmp/mysql.sock',user='zzp',password='zhangzhipeng123',db='mysql')
  File "C:UserszzpAppDataLocalProgramsPythonPython35-32libsite-packagespymysql__init__.py", line 90, in Connect
  return Connection(args, *kwargs)
  File "C:UserszzpAppDataLocalProgramsPythonPython35-32libsite-packagespymysqlconnections.py", line 688, in init
  self.connect()
  File "C:UserszzpAppDataLocalProgramsPythonPython35-32libsite-packagespymysqlconnections.py", line 881, in connect
  sock = socket.socket(socket.AF_UNIX, socket.SOCK_STREAM)
  AttributeError: module 'socket' has no attribute 'AF_UNIX'

百度时有人说删除socket.pyc文件，但我没找到什么socket.pyc文件
有人说是命名冲突。但具体的解决办法是什么呢？

Answer 1

Looking at your error message, I know that the environment you are running in is Windows, but the conn written in your py code is the connection method of the Linux server, and it is also a socket connection