title: PYMYSQL ERROR 2021(1045, "Access denied for user 'root'@'localhost' (using password: YES)")
body: <p>My system:</p>
  <ul>
  <li>Windows 10 pro, version 1909 (build 18363.836)</li>
  <li>Anaconda version: conda 4.10.1</li>
  <li>Python 3.8.5 (python in conda env) and Python 3.9</li>
  <li>Jupyter Lab</li>
  <li>VS code</li>
  </ul>
  <p>Hi! I hope you guys have a great day.</p>
  <p>I have just installed mysql server and mysql workbench on my PC and I have some difficulties when I try to connect my python file to mysql database (I am using mysql workbench as the app) through &quot;sqlalchemy&quot;. I have tried using VS code and Jupyter Lab, both of them yield the same result, nothing.</p>
  <p>This is the code that I use:</p>
  <pre><code>import sqlalchemy as db
  import numpy as np
  import pandas as pd
  import matplotlib.pyplot as plt
  
  engine1 = db.create_engine('mysql+pymysql://root:12345@localhost:3306/sql_store')
  con1 = engine1.connect()
  meta = db.MetaData()
  
  pd.read_sql('SELECT * FROM customers', con1, index_col='customer_id')
  </code></pre>
  <p>By the way, I have tried this code on my &quot;Laptop&quot; (not on my &quot;PC&quot;) and it works well. I am a newbie in this field, so any suggestion would be fantastic since I have been dealing with this issue for days.</p>
  <p>The error that I am getting is this:</p>
  <pre><code>OperationalError: (pymysql.err.OperationalError) (1045, &quot;Access denied for user 'root'@'localhost' (using password: YES)&quot;)
  (Background on this error at: http://sqlalche.me/e/13/e3q8)
  </code></pre>
  <p>Thanks a lot for your time!</p>