Python and MySQL Setup (Windows)

1. Create Project Folder

mkdir python-mysql
cd python-mysql

2. Create Virtual Environment

python -m venv venv

Activate it:

venv\Scripts\activate

3a. Install Required Libraries

pip install mysql-connector-python
pip install pandas pymysql

3b In PyCharm

Create requirements.txt

pandas
pymysql
mysql-connector-python

Then install the packages from command line with

pip install -r requirements.txt