AttributeError: module 'pymysql._auth' has no attribute 'scramble_old_password'

python连接pymysql报错

AttributeError: module 'pymysql._auth' has no attribute 'scramble_old_password'

无法连接虚拟机库

本机新建一个mysql库再连接

import pymysql
conn=pymysql.connect(
    user='root',
    password='123456',
    host='localhost',
    port=3306,
    database='test'
)
cur=conn.cursor()

即可