# 📚 Connecting MySQL with Popular Web Frameworks

#MySQL #WebDev #Frameworks #Django #Laravel #Flask #ASPNET #Spring

MySQL is widely used in web development. Here’s how to connect it with top web frameworks.

---

## 🔹 1. Django (Python) with MySQL
#Django #Python #MySQL
Use mysqlclient or pymysql.

1️⃣ Install the driver:

pip install mysqlclient  # Recommended
# OR
pip install pymysql

2️⃣ Update `settings.py`:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'your_database',
        'USER': 'your_username',
        'PASSWORD': 'your_password',
        'HOST': 'localhost',
        'PORT': '3306',
    }
}

3️⃣ If using `pymysql`, add this to `__init__.py`:

import pymysql
pymysql.install_as_MySQLdb()

---

## 🔹 2. Laravel (PHP) with MySQL
#Laravel #PHP #MySQL
Laravel has built-in MySQL support.

1️⃣ Configure `.env`:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your_database
DB_USERNAME=your_username
DB_PASSWORD=your_password

2️⃣ Run migrations:

php artisan migrate

---

## 🔹 3. Flask (Python) with MySQL
#Flask #Python #MySQL
Use flask-mysqldb or SQLAlchemy.

### Option 1: Using `flask-mysqldb`

from flask import Flask
from flask_mysqldb import MySQL

app = Flask(__name__)

app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER'] = 'your_username'
app.config['MYSQL_PASSWORD'] = 'your_password'
app.config['MYSQL_DB'] = 'your_database'

mysql = MySQL(app)

@app.route('/')
def index():
    cur = mysql.connection.cursor()
    cur.execute("SELECT * FROM your_table")
    data = cur.fetchall()
    return str(data)

### Option 2: Using SQLAlchemy

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://username:password@localhost/your_database'
db = SQLAlchemy(app)

---

## 🔹 4. ASP.NET Core with MySQL
#ASPNET #CSharp #MySQL
Use Pomelo.EntityFrameworkCore.MySql.

1️⃣ Install the package:

dotnet add package Pomelo.EntityFrameworkCore.MySql

2️⃣ Configure in `Startup.cs`:

services.AddDbContext<ApplicationDbContext>(options =>
    options.UseMySql(
        "server=localhost;database=your_database;user=your_username;password=your_password",
        ServerVersion.AutoDetect("server=localhost;database=your_database")
    )
);

---

## 🔹 5. Spring Boot (Java) with MySQL
#SpringBoot #Java #MySQL

1️⃣ Add dependency in `pom.xml`:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.28</version>
</dependency>

2️⃣ Configure `application.properties`:

spring.datasource.url=jdbc:mysql://localhost:3306/your_database
spring.datasource.username=your_username
spring.datasource.password=your_password
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

3️⃣ JPA Entity Example:

@Entity
@Table(name = "users")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;
    // Getters & Setters
}

---

## 🔹 6. Express.js (Node.js) with MySQL
#Express #NodeJS #MySQL
Use mysql2 or sequelize.

### Option 1: Using `mysql2`

const mysql = require('mysql2');

const connection = mysql.createConnection({
    host: 'localhost',
    user: 'your_username',
    password: 'your_password',
    database: 'your_database'
});

connection.query('SELECT * FROM users', (err, results) => {
    console.log(results);
});

### Option 2: Using Sequelize (ORM)

const { Sequelize } = require('sequelize');

const sequelize = new Sequelize('your_database', 'your_username', 'your_password', {
    host: 'localhost',
    dialect: 'mysql'
});

// Test connection
sequelize.authenticate()
    .then(() => console.log('Connected!'))
    .catch(err => console.error('Error:', err));

---

### 📌 Conclusion
MySQL integrates smoothly with all major web frameworks. Choose the right approach based on your stack!

#WebDevelopment #Backend #MySQLIntegration

🚀 Happy Coding! 🚀