import mysql.connector
#mysql (Данные скрыты для сайта python.su)
db_user = "..."
db_password = "..."
db_host = "..."
db_database = "..."
class mysql:
    def register():
        print('\n')
        acc_login = input('New login: ')
        acc_password = input('New password: ')
        database = mysql.connector.connect(user = db_user, password = db_password, host = db_host, database = db_database)
        cursor = database.cursor()
        add_user = ("INSERT INTO `python_users`(`rank`, `name`, `password`) VALUES ('user','{}','{}')".format(acc_login, acc_password))
        cursor.execute(add_user)
        database.commit()
        database.close()
        cursor.close()
        print("ok")
    def auth():
        print('\n')
        acc_login = input('Your login: ')
        database = mysql.connector.connect(user = db_user, password = db_password, host = db_host, database = db_database)
        cursor = database.cursor()
        cursor.execute("SELECT * FROM `python_users`")
        rows = cursor.fetchall()
        for j in rows:
            if acc_login == j[1]:
                acc_password = input('Your password: ')
                if acc_password == j[2]:
                    print("You are authorized")
                    permission = j[0]
                else:
                    print("ERROR Password: ", acc_password)
            else:
                print("ERROR Login: ", acc_login)
    print(permission)