python 在连接mysql数据库的时候提示settimeout ,建议使用python 自带的mysql 代码self.cursor = self.conn.cursor()

#self.cursor = self.conn.cursor(SSDictCursor)  出错代码

正确的完整代码如下：

import pymysql
from pymysql.cursors import SSDictCursor
class Database:
    def __init__(self):
         self.conn = pymysql.connect('localhost','root','root','woniusale',charset='utf8')
         #self.conn = pymysql.Connect(host='127.0.0.1',port=3306,user= 'root',db='woniusale',charset = 'utf8',password='root')
         self.cursor = self.conn.cursor()  #默认游标类型返回的数据为((),(),())

        # 使用SSDictCursor的游标类型来获取数据，此时，数据库返回的数据将会心[{},{},{}]
         #self.cursor = self.conn.cursor(SSDictCursor)
    def query_all(self,sql):
        self.cursor.execute(sql)
        return self.cursor.fetchall()
    def query_one(self,sql):
        self.cursor.execute(sql)
        return self.cursor.fetchone()
    def query_many(self,sql,size):
        self.cursor.execute(sql)
        return self.cursor.fetchmany(size)
    def open_spider(self,spider):
        self.conn = pymysql.Connect(host='localhost',port=3306,user = 'root',db='woniusale',charset = 'utf8' )
        print(self.conn)

if __name__ == '__main__':
    data = Database()
    #data.open_spider()