How to install Python MySQLdb module using pip?

The MySQLdb module is a Python interface for connecting to MySQL databases. Since MySQLdb is not available for Python 3.x, we'll use PyMySQL or mysql-connector-python as modern alternatives.

Why MySQLdb is Not Recommended

MySQLdb only supports Python 2.x and is no longer maintained. For Python 3.x applications, use these alternatives ?

• PyMySQL − Pure Python MySQL client
• mysql-connector-python − Official MySQL driver

Installing PyMySQL (Recommended)

Open Command Prompt and install PyMySQL using pip ?

pip install PyMySQL

Example Usage

import pymysql

# Connection example (won't execute without actual database)
try:
    connection = pymysql.connect(
        host='localhost',
        user='root',
        password='password',
        database='testdb'
    )
    print("Connection successful!")
    connection.close()
except Exception as e:
    print(f"Error: {e}")

Installing mysql-connector-python

Alternative official MySQL connector ?

pip install mysql-connector-python

Example Usage

import mysql.connector

# Connection example
try:
    connection = mysql.connector.connect(
        host='localhost',
        user='root',
        password='password',
        database='testdb'
    )
    print("MySQL connector working!")
    connection.close()
except Exception as e:
    print(f"Error: {e}")

Troubleshooting Installation

If you encounter permission errors, use ?

pip install --user PyMySQL

For system-wide installation with admin rights ?

pip install PyMySQL --upgrade

Comparison

Conclusion

Use PyMySQL or mysql-connector-python instead of MySQLdb for Python 3.x projects. Both provide excellent MySQL connectivity with active community support.