mysql example encrypt 1 (snippet)

Python mysql example 'encrypt 1'

Functions in program:

def user_data():
def con_database(pwd):
def enc_pass(pwd):

Modules used in program:

import mysql.connector
import getpass

python encrypt 1

Python mysql example: encrypt 1

from passlib.hash import pbkdf2_sha256
import getpass
import mysql.connector
def enc_pass(pwd):
    hash=pbkdf2_sha256.encrypt(pwd,rounds=200,salt_size=16)
    return hash
def con_database(pwd):
    cnx=mysql.connector.connect(user='*****',password='*****',host='*******',database='******')
    cursor=cnx.cursor() 
    try:
        query=("INSERT INTO usr VALUES(%s,%s);")
        data=(us,pwd)
        cursor.execute(query,data)
        cnx.commit()
        print("user recorded")
    except Exception as e:
        print(e)

def user_data():
    global us
    print("Please enter username:")
    us=input(">>")
    print("Please enter password:")
    pwd=getpass.getpass(">>")

    return pwd
if __name__=="__main__":
    con_database(enc_pass(user_data()))

Python links

Learn Python: https://pythonbasics.org/
Python Tutorial: https://pythonprogramminglanguage.com