[Python] cryptography is required for sha256_password or caching_sha2_password

I used the following python code and got this error.

Print(e) = "cryptography is required for sha256_password or
caching_sha2_password"


And have no idea how to solve the error.

import pymysql as db

HOST = "XXXXX.XXX.XX”
PORT = XXXX
USER = "my_username"
PASSWORD = "my_password”
DB = "db_name"

try:
connection = db.Connection(host=HOST, port=PORT,user=USER,
passwd=PASSWORD, db=DB)

dbhandler = connection.cursor()
dbhandler.execute("SELECT * from table_name")
result = dbhandler.fetchall()
for item in result:
print (DB)
except Exception as e:
print(e)

finally:
connection.close()

Continue reading...