Question

How to create connection to MySQL database with Python

Answer 1

# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd=""
)

print(db)
print(db.connection_id)


'''
run:

<mysql.connector.connection.MySQLConnection object at 0x0152D4D0>
28

'''

 

70+ SQL courses for beginners and professionals