pymysql模块操作数据库及连接报错解决方法

import pymysql

sql = "select host,user,password from user" #想要执行的MySQL语句

#sql = 'create database sss character set utf8'

#打开数据库连接

db = pymysql.connect(host="192.168.254.40", user="root",

                     password="root", db="mysql", port=3306)

cur = db.cursor()#使用cursor()方法获取操作游标