Connect to MySQL with Python, SQLAlchemy, Pandas and Heroku

Here is the project instructions and code:

00:00 - Introduction
01:03 - What is SQL
05:10 - Practice SQL with SQLBolt
06:15 - Cloning the Github repository
09:47 - Your database credentials
12:33 - Understanding the project template and basic structure
12:57 - PIP Python Package Manager
14:50 - Dot Env File (Environment Variables)
18:33 - Running and testing the code for the first time
21:38 - Connecting to the database using SQL Alchemy
22:30 - Running your first SQL Statement to create a table
25:43 - Inserting data into the database
27:03 - Use pandas to select and retrieve data from the database

[jeanfabraruiz]

Excelent video. Pretty sure more people will find this useful in future. Right now I'm trying to deploy an API to Heroku, the API already works locally and its connected to a mysql database. However, when I try to open the app in Heroku the connection with pymysql conector is dennied. Any idea why this is happening?