Python can be used in database applications.
One of the most popular databases is MySQL.
To be able to experiment with the code examples in this tutorial, you should have MySQL installed on your computer.
You can download a MySQL database at https://www.mysql.com/downloads/.
Install MySQL Driver
Python needs a MySQL driver to access the MySQL database.
In this tutorial we will use the driver "MySQL Connector".
We recommend that you use PIP to install "MySQL Connector".
PIP is most likely already installed in your Python environment.
Navigate your command line to the location of PIP, and type the following:
Download and install "MySQL Connector":
Now you have downloaded and installed a MySQL driver.
Test MySQL Connector
To test if the installation was successful, or if you already have "MySQL Connector" installed, create a Python page with the following content:
If the above code was executed with no errors, "MySQL Connector" is installed and ready to be used.
Learn to Filter Data in Python Like a Data Analyst
Try a hands-on training sessions with step-by-step guidance from an expert. Try the guided project made in collaboration with Coursera now!Get started
Start by creating a connection to the database.
Use the username and password from your MySQL database:
mydb = mysql.connector.connect(
Now you can start querying the database using SQL statements.