Connect Python to MySQL with XAMPP | Full Step-by-Step Tutorial for Beginners

in this beginner-friendly tutorial, I’ll show you how to connect Python to a MySQL database using XAMPP. This is a key step for building real-time dashboards, running data analysis, or creating full applications using your local database.

*What You’ll Learn* :
• Install and run MySQL using XAMPP
• Create a MySQL database using phpMyAdmin
• Write a simple Python script to connect to MySQL

✅ Perfect for data analysts, developers, or students learning Python and SQL.

📦 Tools: Python, MySQL, XAMPP, mysql-connector-python

📺 Coming up next: Build a real-time dashboard using Streamlit + MySQL!

Or
Link to donate on paypay:

===== *Continue your learning* ========
Get the Data Analytics Kickstart eBook—your all-in-one beginner guide to Python, SQL & Power BI.

⏳ *Timestamps* ⏳
00:00 Intro & what we will cover in this video
00:20 Start the download XAMPP Apache process
02:32 Start control panel to run MySQL
03:55 A walk-through of the buttons in the XAMPP Control Panel
04:34 Open phpMyAdmin from browser
05:11 Create a Test database in phpMyAdmin
06:47 Connecting Python to MySQL using a simple test script
07:45 Open Visual Studio (VS Code).
10:52 Open Terminal in VS Code to run Python code.
11:33 Done! Ending statement.

Disclaimer: This content is for educational purposes only. Affiliate links may be included, and I may earn a small commission at no extra cost to you. Thank you for supporting the channel!