connect to sql server using python using mysql connector code example
Example 1: python install mysql connector
pip3 install mysql-connector-python #Python 3
pip install mysql-connector-python
Example 2: mysql connection python
from sqlalchemy import types, create_engine
import pymysql
try:
conn = create_engine('mysql+pymysql://user:pass@IP/database_name')
print("MySQL Connection Sucessfull!!!!!!!!!!!")
except Exception as err:
print("MySQL Connection Failed !!!!!!!!!!!")
print(err)