How you can Set up MySQL Driver in Python
To start utilizing MySQL in Python, it’s worthwhile to do the next:
Step 1 – Set up the MySQL Connector#
Utilizing pip
, we will set up the MySQL Connector package deal:
python -m pip set up mysql-connector-python
Step 2 – Take a look at the MySQL Connector#
Create a Python file and import the brand new package deal:
import mysql.connector
Step 3 – Create a Connection to the MySQL Database#
Now you may create a connection to your MySQL database.
Create a file known as app.py
and place the next inside:
import mysql.connector
your_database = mysql.connector.join(
host = "localhost"
person = "username"
password = "YoUrPaSsWoRd"
)
print(your_database)
Step 4 – Run the applying#
Now run the app.py
Python script to see our connection happen:
python app.py