ubuntu中使用Python脚本连接mysql出错：pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: YES)")

Question

from pymysql import connect


class JD(object):
    def __init__(self):
        pass

    def show_all_items(self):
        """显示所有的商品"""
        conn = connect(host="localhost",port=3306,user="root",password="root",database="jing_dong",charset="utf8")  
        cursor = conn.cursor()
        cursor.execute("select * from goods;")
        for temp in cursor.fetchall():
            print(temp)
        # 关闭Cursor对象
        cursor.close()
        conn.close()

    def show_cates(self):
        conn = connect(host="localhost",port=3306,user="root",password="root",database="jing_dong",charset="utf8")  
        cursor = conn.curson()
        cursor.execute("select name from goods_cates;")
        for temp in cursor.fetchall():
            print(temp)
        # 关闭Cursor对象
        cursor.close()
        conn.close()

    def run(self):
        while True:
            print("------欢迎来到京东商城------")
            print("1:所有的商品")
            print("2:所有的商品分类")
            print("3:所有的商品品牌分类")
            num = input("请输入功能对应的序号：")

            if num == "1":
                # 查询所有商品
                self.show_all_items()
            elif num == "2":
                # 查询分类
                self.show_cates()
            elif num == "3":
                # 查询商品分类
                pass
            else:
                print("输入有错，请重新输入！")


def main():
    # 1.创建一个京东商城对象
    jd = JD()
    # 2.调用这个对象的run方法，让其运行
    jd.run()


if __name__ == "__main__":
    main()

Answer 1

更改数据库密码重新连接一下就好了