Подключение SQL к Python

Подключение SQL к Python

 pip install mysql-connector-python

import mysql.connector

from getpass import getpass 
from mysql.connector import connect, Error 
 
try: 
    with connect( 
        host="localhost", 
        user=input("Имя пользователя: "), 
        password=getpass("Пароль: "), 
    ) as connection: 
        print(connection) 
except Error as e: 
    print(e)

CREATE DATABASE online_movie_rating;

try: 
    with connect( 
        host="localhost", 
        user=input("Имя пользователя: "), 
        password=getpass("Пароль: "), 
    ) as connection: 
        create_db_query = "CREATE DATABASE online_movie_rating" 
        with connection.cursor() as cursor: 
            cursor.execute(create_db_query) 
except Error as e: 
    print(e)

try: 
    with connect( 
        host="localhost", 
        user=input("Введите имя пользователя: "), 
        password=getpass("Введите пароль: "), 
    ) as connection: 
        show_db_query = "SHOW DATABASES" 
        with connection.cursor() as cursor: 
            cursor.execute(show_db_query) 
            for db in cursor: 
                print(db) 
except Error as e: 
    print(e)