How to connect to MySQL using python

Mostly PIP Installed in Python, so using PIP you Install MySQL Connector.

For Installation command for Windows/Linux/Ubuntu/Mac OS ,Follow below link for description.

https://pynative.com/install-mysql-connector-python/

Prerequisites for connect to MySQL:

1.Database Name : Here you provide Database name which you want to connect.

2. Host Name : Here you provide server name Example: if you work on local system then your Hostname is "localhost".

3. Username: username that want to work on MySQL Example: "Root" is Default username in MySQL.

4. Password : During Mysql Installation time if you provide password to it then This is password to connect MySQL. If you use Root User then you don't need of password.

Here we try to connect MySQL to python with Default user "Root"

import mysql.connector
connection = mysql.connector.connect(host='localhost',
database='db_Employee',
user='Root',
password=' ')
print(connection)

If you work on your username and password then code for Connection is:

import mysql.connector
connection = mysql.connector.connect(host='localhost',
database='db_Employee',
user='username',
password=' password')
print(connection)

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akshay Shedwad6y ago
Accepted answer
Mostly PIP Installed in Python, so using PIP you Install MySQL Connector.

For Installation command for Windows/Linux/Ubuntu/Mac OS ,Follow below link for description.

https://pynative.com/install-mysql-connector-python/

Prerequisites for connect to MySQL:

1.Database Name : Here you provide Database name which you want to connect.

2. Host Name : Here you provide server name Example: if you work on local system then your Hostname is "localhost".

3. Username: username that want to work on MySQL Example: "Root" is Default username in MySQL.

4. Password : During Mysql Installation time if you provide password to it then This is password to connect MySQL. If you use Root User then you don't need of password.

Here we try to connect MySQL to python with Default user "Root"
import mysql.connector

connection = mysql.connector.connect(host='localhost',
                                         database='db_Employee',
                                         user='Root',
                                         password=' ')

print(connection)
If you work on your username and password then code for Connection is:
import mysql.connector

connection = mysql.connector.connect(host='localhost',
                                         database='db_Employee',
                                         user='username',
                                         password=' password')

print(connection)
Sagar Lad5y ago
Hi Guru,

Please check this article : https://pynative.com/python-mysql-database-connection/
Guru G6y ago
Thanks you so much Akshay sir
Rajanikant Hawaldar6y ago
https://pynative.com/python-mysql-database-connection/ https://youtu.be/x7SwgcpACng https://youtu.be/WidUq_jHJLghttps://www.tutorialspoint.com/python/python_database_access.htmhttps://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python