"cryptography is required for sha256_password or caching_sha2_password"

Question

Good day. Hope your all are well. Can someone help me with fix this?

I'm new to the MySQL environment. I'm trying to connect to MySQL Database remotely. 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()

Answer 1

The error message can be made more comprehensive and helpful. In order to fix this "cryptography" package needs to be installed.

pip install cryptography

Answer 2

To use “sha256_password” or “caching_sha2_password” for authenticate, you need to install additional dependency:

$ python3 -m pip install PyMySQL[rsa]

Source: https://pymysql.readthedocs.io/en/latest/user/installation.html

Answer 3

For what it's worth, I had this problem today using MySQL via SQLAlchemy in Python. It turned out that I was using the wrong password for this account. In other words, if you have this problem, you might want to start by just confirming that you're using the correct password.

FWIW, I am not sure why this generated a cryptography message. Something buggy along the way?

Answer 4

"This report means that sha256_password with caching_sha2_password These two encryption algorithms need to use cryptography.
Although the meaning is clear, you may not know how to solve it.
Actually, cryptography is a python package, so the solution is simple:"

Try running pip install cryptography on you cmd or terminal.
Here is the source.