How to Set Up Flask with MySQL in Visual Studio Code (VS Code) | Step-by-Step Guide

Want to connect **Flask with MySQL** in **Visual Studio Code (VS Code)?** 🔥 In this step-by-step tutorial, we’ll guide you through setting up a Flask web application and integrating it with a MySQL database. This is perfect for **web developers** and **backend engineers** looking to build dynamic, database-driven applications using Flask and MySQL. --- ### **🔹 What You’ll Learn in This Video:** ✅ Installing Flask and MySQL in VS Code ✅ Setting Up a Virtual Environment in VS Code ✅ Installing `Flask-MySQL` Connector ✅ Creating a Flask App with MySQL Integration ✅ Running SQL Queries from Flask ✅ Performing CRUD Operations in Flask --- ## **🔹 Prerequisites** Before starting, ensure you have: ✔️ **Python 3.x** installed → [Download Python](https://www.python.org/downloads/) ✔️ **MySQL Server** installed → [Download MySQL](https://dev.mysql.com/downloads/) ✔️ **VS Code** installed → [Download VS Code](https://code.visualstudio.com/) ✔️ **MySQL Workbench (Optional) for Database Management** --- ## **🔹 Step-by-Step Guide** ### **1️⃣ Install Required Packages** Open **VS Code Terminal** and run the following commands: ```bash # Create a project directory mkdir flask-mysql && cd flask-mysql # Create a virtual environment python -m venv venv source venv/bin/activate # Windows: venv\Scripts\activate # Install Flask and MySQL Connector pip install flask flask-mysql mysql-connector-python ``` --- ### **2️⃣ Set Up a Flask Application** Create a file named **`app.py`** and add the following Flask code: ```python from flask import Flask, render_template import mysql.connector app = Flask(__name__) # Configure MySQL Connection db = mysql.connector.connect( host="localhost", user="your_username", password="your_password", database="your_database" ) cursor = db.cursor() @app.route('/') def home(): cursor.execute("SELECT 'Hello, Flask with MySQL!'") message = cursor.fetchone()[0] return f"[h1]{message}[/h1]" if __name__ == "__main__": app.run(debug=True) ``` Replace `"your_username"`, `"your_password"`, and `"your_database"` with your actual MySQL credentials. --- ### **3️⃣ Create a MySQL Database** Log in to MySQL via terminal or MySQL Workbench and run: ```sql CREATE DATABASE flaskdb; USE flaskdb; CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), email VARCHAR(100) UNIQUE ); INSERT INTO users (name, email) VALUES ('John Doe', '[email protected]'); ``` --- ### **4️⃣ Run Flask App in VS Code** To start the Flask app, run: ```bash python app.py ``` Visit **http://127.0.0.1:5000/** in your browser, and you should see **"Hello, Flask with MySQL!"** --- ### **5️⃣ Fetch Data from MySQL in Flask** Modify **`app.py`** to display database records: ```python @app.route('/users') def users(): cursor.execute("SELECT * FROM users") users_list = cursor.fetchall() return f"[h2]Users:[/h2]" + " 8br 9".join([f"{user[1]} - {user[2]}" for user in users_list]) ``` Restart Flask and visit **http://127.0.0.1:5000/users** to see database records. --- ## **🔹 Who Is This Tutorial For?** ✅ Python & Flask Developers ✅ Backend Engineers Working with Databases ✅ Anyone Looking to Build Web Apps with Flask & MySQL --- ## **🔹 Resources Mentioned in This Video:** 📌 Flask Documentation → [https://flask.palletsprojects.com/](https://flask.palletsprojects.com/) 📌 MySQL Documentation → [https://dev.mysql.com/doc/](https://dev.mysql.com/doc/) 📌 VS Code Download → [https://code.visualstudio.com/](https://code.visualstudio.com/) --- ## **💡 Pro Tips for Smooth Setup** ✔ Ensure MySQL Server is **running** before connecting. ✔ Always use **virtual environments** for Python projects. ✔ Use **Flask-SQLAlchemy** for an ORM-based approach. ✔ If you get connection errors, **check your MySQL username/password.** --- ## **👍 Like, Share & Subscribe!** If this tutorial helped you, please **LIKE, SHARE, and SUBSCRIBE** for more **Flask, Python, and Web Development** tutorials! 🚀 💬 Got questions? Drop them in the **comments** below! --- ### **🔹 Hashtags:** #Flask #MySQL #Python #VSCode #WebDevelopment #FlaskTutorial #Database #PythonMySQL #BackendDevelopment #SQL Start building powerful Flask apps with MySQL today! 🐍🔥