In this Python tutorial, we will be working on MySQL database connection with Python. In easy words, we will learn how to connect MySQL with Python program.
So we are going to make this tutorial easy to understand. In order to do that we will separate this tutorial into three parts.
In this post I go over the steps to install XAMPP, Python, and then Django on a Windows XP system. I have also listed the sites that helped me create the setup in my Windows XP machine. Here are the steps I followed to setup the Django web framework on my Windows XP machine. WAMP stands for Windows, Apache, MySQL, and anyone of PHP, Perl, or Python. WAMP server is a local webserver for running the scripting language (PHP, Perl) and this is open source. XAMPP stands for Cross-Platform (X), Apache (A), Maria DB (M), PHP (P), and Perl (P). It is developed by Apache Friends. Objective: XAMPP is already installed in a Windows environment and we are accustomed to maintaining websites based on PHP as the programming language. But what about Python? Instructions:. Downloa.
I am using xampp for my database. This is an optional step, if you have MySQL already installed then you can skip this step. Before starting coding run the xampp control panel and start Apache & MySQL.
- What we need to connect the MySQL Database with Python.
- Starting Database server.
- The Python Program to establish a connection with MySQL in Python.
With those above three steps, we gonna achieve our goal to connect MySQL Database with Python or Establish a connection between Python program and MySQL Database.
This tutorial is a part of our MySQL Tutorial in Python,
Connect MySQL Database in Python
Let's take a look at the requirements to build a connection between our Python program and MySQL Database.
At the very first we must need to have a connector. We can use MySQL Connector/Python.
In my previous tutorial, I have described How to install MySQL Connector in Python step by step. If you don't know how to do this please go through the tutorial.
After installing MySQL Connector/Python start your MySQL Server.
( You may start whenever you want before you run your Python program )
Run MySQL Server
To run or start your MySQL server you can use cmd. If you are using XAMPP server then it will be easy for you as you will see an option to start apache and MySQL both in the XAMPP control panel.
Python program to connect MySQL Database with Python
After staring your MySQL server use the following code to check if everything is alright or not.
host – put your hostname here. In general, you are running on your local machine it will be localhost or 127.0.0.1
user and passwd are the variables to store your MySQL server username and password.
It is recommended to use MySQL administrative password so that you can get all the privileges.
database is the variable to store your database name.
Put your database name here. ( If you want to work with a particular database put the database name here )
So all the required things are now stored in the variable mydb
If everything is fine. You should get an output
Or if anything went wrong you will get errors while executing your Python program.
Python On Xampp
Xampp Control Panel Download
To run or start your MySQL server you can use cmd. If you are using XAMPP server then it will be easy for you as you will see an option to start apache and MySQL both in the XAMPP control panel.
Python program to connect MySQL Database with Python
After staring your MySQL server use the following code to check if everything is alright or not.
host – put your hostname here. In general, you are running on your local machine it will be localhost or 127.0.0.1
user and passwd are the variables to store your MySQL server username and password.
It is recommended to use MySQL administrative password so that you can get all the privileges.
database is the variable to store your database name.
Put your database name here. ( If you want to work with a particular database put the database name here )
So all the required things are now stored in the variable mydb
If everything is fine. You should get an output
Or if anything went wrong you will get errors while executing your Python program.
Python On Xampp
Xampp Control Panel Download
If you are still having a problem with your connection please let us know by commenting in the below comment section.
Python Xampp Flask
Hi Guys -hope all good. I tried the above code in Jupyter editor however there is no response from MySQL stored in xampp. No errors.
Would the exact file location need to be specified in the code? Thanks.Thank you for the update – connection to MySQL server was successful.
Thanks
its doneThis error pops up when I try to connect my python to the sql
Traceback (most recent call last):
File 'C:UsersUSERAppDataLocalProgramsPythonPython38-32mysqlconnect.py', line 1, in
import mysql.connector
ModuleNotFoundError: No module named ‘mysql'
Django Xampp
Leave a Reply
