I can't connect my database on Jupyter Notebooks

Question

This is the code I need to use to connect the database but it gives me the error shown below.

The code:

%sql mysql+pymysql://root:botsebontle22@localhost:3306/united_nations

The Error:

MetaData.init() got an unexpected keyword argument 'bind' Connection info needed in SQLAlchemy format, example: postgresql://username:password@hostname/dbname or an existing connection: dict_keys([])

I have already installed the necessary packages on my environment but nothing seems to be working.

Answer 1

you need to downgrade sqlaclchemy to version 1.4.4. Do this by running pip install sqlalchemy==1.4.4. after you are done, restart the kernel in jupyter notebook and run all the cells. it should work