0

DatabaseError: (mysql.connector.errors.DatabaseError) 2005 (HY000): Unknown MySQL server host '@127.0.0.1' (11003) (Background on this error at: https://sqlalche.me/e/14/4xp6)

engine = create_engine('mysql+mysqlconnector://root:****@@127.0.0.1:3306/pga', echo=False)

pga = pd.read_csv(r'C:\Users\micha\OneDrive\Desktop\PGA\ASA All PGA Raw Data - Tourn 
Level.csv', engine.connect())
mcq7
  • 5
  • 3
  • Is there supposed to be 2 `@` symbols in there? I haven't used sqlalchemy, but that doesn't feel right and the error message suggests that it thinks the host is literally `@127.0.01` instead of `127.0.0.1`. – JNevill Jan 18 '22 at 21:48
  • Hey yeah that is apart of my password as well... meant to leave that out – mcq7 Jan 18 '22 at 21:55
  • I'm glad you left it in, since it pointed to the problem. Did the link/duplicate question/answer help out? – JNevill Jan 19 '22 at 15:05

0 Answers0