mikailshah2005

from getpass import getpass from mysql.connector import connect,Error

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

create_movies_table_query = """CREATE TABLE movies( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(100), release_year YEAR(4), genre VARCHAR(100), collection_in_mil INT ) """ with connection.cursor() as cursor: cursor.execute(create_movies_table_query) connection.commit()

create_reviewers_table_query = """CREATE TABLE reviewers ( id INT AUTO_INCREMENT PRIMARY KEY, first_name VARCHAR(100), last_name VARCHAR(100) ) """ with connection.cursor() as cursor: cursor.execute(create_reviewers_table_query) connection.commit()

create_ratings_table_query = """CREATE TABLE ratings ( movie_id INT, reviewer_id INT, rating DECIMAL(2,1), FOREIGN KEY(movie_id) REFERENCES movies(id), FOREIGN KEY(reviewer_id) REFERENCES reviewers(id), PRIMARY KEY(movie_id, reviewer_id) ) """

with connection.cursor() as cursor: cursor.execute(create_ratings_table_query) connection.commit()

ВЫХОДИТ ОШИБКА: File "c:\Users\User\Desktop\C++\mainpy\main.py", line 23, in with connection.cursor() as cursor:

  File "C:\Users\User\AppData\Local\Programs\Python\Python313\Lib\site-packages\mysql\connector\connection.py", line 1242, in cursor
    raise OperationalError("MySQL Connection not available")
mysql.connector.errors.OperationalError: MySQL Connection not available
PS C:\Users\User\Desktop\C++> 

ПОЖАЛУЙСТА ОБЪЯСНИТЕ ЧТО НЕ ТАК??