How to Install MySQLdb module for Python on MacOS?

MySQLdb stands for My Structured Query Language Database and is an interface for connecting to a MySQL database server from Python. It is constructed on top of the MySQL C API and implements the Python Database API v2.0.

Advantages of using MySQLdb

• Data protection: MySQLdb is a very secure and reliable database, which is the reason why Twitter, Facebook, and WordPress use it for their database.
• High efficiency: My SQL contains a storage engine that makes it easier to control and manage your system very efficiently
• High transactional speed: MySQL is one of the fastest transactional database solutions available today.
• Easy to use: You need not waste much time to set up this program because downloading and installation takes less than nearly 10 minutes.

MySQLdb is supported on the following operating systems.

• macOS
• Windows 64-bit
• Linux 64-bit

Steps to install MySQLdb on MacOS

Step 1: Go to the link and download the MySQL dmg file.

Screenshot 1

Step 2: After clicking on it, the download will begin in your browser.

Screenshot 2

Step 3: After the download is finished run the setup on your system.

Screenshot 3

Step 4: Install MYSQL 8.0.31-community box appears. Click on continue on each page of the setup.

Screenshot 4

Step 5: Now in configuring the MySQL server set the password for the “root” user.

Screenshot 5

Step 6: After that, click on close and exit your setup.

Screenshot 6

MySQLdb is successfully installed on your macOS.

Verifying the Installation

Step 1: Open the system setting on your mac and scroll to the bottom.

Screenshot 7

You can see the MySQLdb installed on your device.