Python Mysql Connector Example

Chapter: Python Last Updated: 21-11-2020 05:25:56 UTC

Program:

            /* ............... START ............... */
                
import mysql.connector
print("Opening mysql connection")

connect_var = mysql.connector.connect(user='root', password='pwd', 
host='127.0.0.1', database='userlist')

#if you running locally you can use without host also
connect_var = mysql.connector.connect(user='root', password='pwd',
database='userlist')

connect_var.close()
                /* ............... END ............... */
        

Notes:

  • First step to install mysql python connector, for that we have to install the same using pip (package manager for Python)
  • Below command will install pip in windows
  • pip install -U pip
  • For installing mysqlclient in your machine please type below command
  • pip install mysqlclient
  • If you want to install mysql-connector-python in system please follow the below command
  • pip install mysql-connector-python
  • Python mysql connector is used to connect python to mysql database.
  • The connect() constructor creates a connection to the MySQL server.
  • The connect() constructor is used in mysql to return MySQLConnection object.
Similar Programs Chapter Last Updated
Python Program To Check Whether Element Present In Set Or Not Example Python 04-10-2023
Python Program To Find Maximum And Minimum Number In A Set Python 04-10-2023
Python Program To Check Symmetric Matrix Python 04-10-2023
Python Program To Find Subsets Of A Set Python 04-10-2023
Python Program To Find Power Set Of A Set Python 04-10-2023
Remove All Duplicates From List Python Python 04-10-2023
Python Program To Find Symmetric Difference Of Two Sets Python 27-09-2023
Python Program To Find Common Item From Two Set Python 27-09-2023
Python Program To Get Unique Values From A List Python 27-09-2023
Python Encode And Decode String With Key Python 24-09-2023
Python Simple Encrypt Decrypt String Python 24-09-2023
Python Format String To Specific Length Python 24-09-2023
Python Code To Check If String Contains Substring Python 24-09-2023
Python Program To Find Most Repeated Word In A String Python 23-09-2023
Split String Into Words Python Python 23-09-2023
Remove All Punctuation Python Python 23-09-2023
Python Program To Reverse An Array Python 23-09-2023
Python Program To Find Number Of Palindrome In A String Python 23-09-2023
Python Program To Find Longest Common Substring Python 23-09-2023
Python Program To Find Number Of Days In A Given Month And Year Python 22-09-2023
Python Program To Calculate Age Of A Person Python 22-09-2023
Python Code To Get Day Of Week Python 22-09-2023
Python Convert String To Date Without Time Python 22-09-2023
Python Program To Print Current Date And Time In Format dd/mm/yyyy Python 22-09-2023
Python Program To Find Working Days In A Month Python 19-09-2023
Python Code To Change Date Format Python 16-09-2023
Python Program To Calculate Number Of Days Between Two Dates Python 16-09-2023
Python Program To Calculate Age In Years Months And Days Python 16-09-2023
Python Program To Schedule A Job To Run After A Certain Amount Of Time Python 10-08-2023
Python Program To Schedule A Job To Run Randomly Once A Day Python 10-08-2023

1 2 3 4