인프런 커뮤니티 질문&답변

mysql 과 mysql workbench를 설치하고 접속하려는데 안돼서 고생하고 있습니다.

코드는 아래와 같고

'code'

from fastapi import FastAPI, Depends

from sqlalchemy.orm import Session

from sqlalchemy import Column, Integer, String, create_engine

from sqlalchemy.ext.declarative import declarative_base

from pydantic import BaseModel

DATABASE_URL = "mysql+pymysql://newjeans:@gaius2127@localhost:3306/db_name"

engine = create_engine(DATABASE_URL)

Base = declarative_base()

class User(Base):

    __tablename__ = 'users'

    id = Column(Integer, primary_key=True, index=True)

    username = Column(String(50), unique=True, index=True)

    email = Column(String(120))

class UserCreate(BaseModel):

    username: str

    email: str

def get_db():

    db = Session(bind=engine)

    try:

        yield db

    finally:

        db.close()

Base.metadata.create_all(bind=engine)

app = FastAPI()

@app.get("/")

def read_root():

    return {"message": "Now, tackle with mySQL"}

@app.post("/users/")

def create_user(user: UserCreate, db: Session = Depends(get_db)):

    new_user = User(username=user.username, email=user.email)

    db.add(new_user)

    db.commit()

    db.refresh(new_user)

    return {"id": new_user.id, "username": new_user.username, "email": new_user.email}

터미널에 메세지는

PS C:\wonnho\fastapi> python -m uvicorn main:app --reload

INFO: Will watch for changes in these directories: ['C:\\wonnho\\fastapi']

INFO: Uvicorn running on http://127.0.0.1:8000 (Press CTRL+C to quit)

INFO: Started reloader process [20636] using StatReload

Process SpawnProcess-1:

Traceback (most recent call last):

File "C:\Python312\Lib\site-packages\pymysql\connections.py", line 644, in connect

sock = socket.create_connection(

^^^^^^^^^^^^^^^^^^^^^^^^^

File "C:\Python312\Lib\socket.py", line 828, in create_connection

for res in getaddrinfo(host, port, 0, SOCK_STREAM):

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "C:\Python312\Lib\socket.py", line 963, in getaddrinfo

for res in _socket.getaddrinfo(host, port, family, type, proto, flags):

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

socket.gaierror: [Errno 11003] getaddrinfo failed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "C:\Python312\Lib\site-packages\sqlalchemy\engine\base.py", line 3280, in wrappool_connect

return fn()

^^^^

중간 생략.....

File "C:\Python312\Lib\site-packages\pymysql\connections.py", line 358, in init

self.connect()

File "C:\Python312\Lib\site-packages\pymysql\connections.py", line 711, in connect

raise exc

sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'gaius2127@localhost' ([Errno 11003] getaddrinfo failed)")

(Background on this error at: https://sqlalche.me/e/14/e3q8)

아이디와 패스워드가 문제인거 같은데 뭐가 문제인지 모르겠네요. 륀튼에게 물어보고 제미나이도 물어봤는데 해결이 안되어 힌트라도 얻을려고 질문합니다.위에 newjeans라는 아이디가 있음.