What is MySQLdb?

Categories: Python

MySQLdb is an interface for connecting to a MySQL database server from Python. It implements the Python Database API v2.0 and is built on top of the MySQL C API.

How do I Install MySQLdb?

Before proceeding, you make sure you have MySQLdb installed on your machine. Just type the following in your Python script and execute it −

#!/usr/bin/python

import MySQLdb

If it produces the following result, then it means MySQLdb module is not installed −

Traceback (most recent call last):

File "test.py", line 3, in <module>

import MySQLdb

ImportError: No module named MySQLdb

Top articles
What is used of Python? Some uses with practical Python Published at:- Some Advanced Features of Python and Its uses Published at:- Python Interview Question and Answer Published at:- Python Introduction Published at:- Benefits of Python Programming Language Published at:- Introduction to Careers in Python Published at:- Advantages of Python Published at:- AWS Control Tower now supports Python 3.9 runtime Published at:- Hello World using Python Program. Published at:- Features of Python Published at:- History of Python Published at:- Loper al Environment Setup of Python Published at:- Getting Python on the Appliper ation Published at:- Python Identifiers Published at:- Lines and Indentation in the Python Published at:- Multi-Line Statements in the python Published at:- Quotation in Python Published at:- Comments in Python Published at:- Using Blank Lines in Python Published at:- Assigning Values to Variables in the Python Published at:- Multiple Assignment in the Python Published at:- Standard Data Types Published at:- Python Comment Published at:- Multiple Python Statement in One Line on the Comment Published at:- Strings Python Statements In Comment Published at:- Python Indentation Published at:- What are Python Variables? Published at:- Python Strings Published at:- Python String Program Published at:- Python Lists Published at:- Python Tuples Published at:- Python Dictionary Published at:- Data Type Conversion Published at:- Different Types of Operators in the Python Published at:- Python Arithmetic Operators Published at:- Python Comparison Operators Published at:- Python Assignment Operators Published at:- Python Bitwise Operators Published at:- Python Logical Operators Published at:- Python Membership Operators Published at:- Python Identity Operators Published at:- Highest Precedence in Python Operators Published at:- Python - Decision Making Published at:- Single Statement In Python Published at:- Functions in Python Published at:- Defining a Function Published at:- Syntax in Python Published at:- Example of Python Published at:- Calling a Function Published at:- Function Arguments Published at:- Required arguments Published at:- Keyword arguments Published at:- Default arguments Published at:- Variable-length arguments Published at:- The Anonymous Functions Published at:- The return Statement Published at:- Scope of Variables Published at:- Global vs. Local variables Published at:- Default arguments Published at:- Variable-length arguments Published at:- The Anonymous Functions Published at:- The return Statement Published at:- Python - Modules Published at:- The import Statement Published at:- Locating Modules Published at:- The PYTHONPATH Variable Published at:- Namespaces and Scoping Published at:- The dir( ) Function Published at:- The globals() and locals() Functions Published at:- The reload() Function Published at:- Packages in Python Published at:- Python - Files I O Published at:- The raw_input Function Published at:- The input Function Published at:- Opening and Closing Files Published at:- The open Function Published at:- The file Object Attributes Published at:- The close() Method Published at:- Reading and Writing Files Published at:- The read() Method Published at:- File Positions Published at:- Renaming and Deleting Files Published at:- The remove() Method Published at:- Directories in Python Published at:- The chdir() Method Published at:- The getcwd() Method Published at:- The rmdir() Method Published at:- File & Directory Related Methods Published at:- Python - Exceptions Handling Published at:- Assertions in Python Published at:- The assert Statement Published at:- What is Exception? Published at:- Handling an exception Published at:- Argument of an Exception Published at:- Raising an Exceptions Published at:- User-Defined Exceptions Published at:- Python - Object Oriented Published at:- Overview of OOP Terminology Published at:- Creating Classes Published at:- Creating Instance Objects Published at:- Accessing Attributes Published at:- Built-In Class Attributes Published at:- Destroying Objects Published at:- Class Inheritance in Python Published at:- Base Overloading Methods Published at:- Overloading Operators in Python Published at:- Data Hiding Published at:- Python - Object Oriented Published at:- Creating Instance Objects Published at:- Accessing Attributes Published at:- Built-In Class Attributes Published at:- Class Inheritance Published at:- Python - CGI Programming Published at:- Web Browsing in Python Published at:- Web Server Support and Configuration In Python Published at:- HTTP Header In Python Published at:- CGI Environment Variables Published at:- Passing Information using GET method Published at:- Simple FORM Example:GET Method In Python Published at:- Passing Information Using POST Method In Python Published at:- Passing Radio Button Data to CGI Program Published at:- Passing Text Area Data to CGI Program Published at:- Using Cookies in CGI Published at:- How It Works In Python ? Published at:- Setting up Cookies In Python Published at:- How To Raise a "File Download" Dialog Box? Published at:- Python - MySQL Database Access Published at:- What is MySQLdb? Published at:- Database Connection In Python Published at:- Creating Database Table In Python Published at:- Python - Regular Expressions Published at:- The match Function Published at:- Regular Expression Modifiers: Option Flags Published at:- Regular Expression Patterns Published at:- What is Sockets? Published at:- The socket Module Published at:- Server Socket Methods Published at:- General Socket Methods Published at:- What is Simple Server Published at:- A Simple Client Published at:- Python Internet modules Published at:- Further Readings Published at:- Python - Sending Email using SMTP Published at:- Sending an HTML e-mail using Python Published at:- Sending Attachments as an E-mail Published at:- Python - Multithreaded Programming Published at:- Starting a New Thread Published at:- Python Lambda Published at:- Python Dictionaries Published at:- Ordered or Unordered? Published at:- Python Casting Published at:- What is an Array? Published at:- Python Iterators Published at:- Python Scope Published at:- Global Scope Published at:- Python Dates Published at:- What is PIP? Published at:- File Handling Published at:- Python File Open Published at:- Python File Write Published at:- NumPy Tutorial Published at:- Python - MySQL Database Access Published at:- What is MySQLdb? Published at:- Database Connection in Python Published at:- READ Operation Published at:- Python Tools Utilities Published at:- Python - Multithreaded Programming Published at:- Synchronizing Threads Published at:- Python - XML Processing Published at:- Python - GUI Programming Published at:-
R4Rin Team
The content on R4Rin.com website is created by expert teams.