Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- connection_string = "DRIVER={MySQL};SERVER={server_name}.mysql.database.azure.com;PORT=3306;DATABASE"
- "={my_database_name};UID={username@server_name};PWD={password};CHARSET=UTF8;"
- "sslca=/home/sachin/BaltimoreCyberTrustRoot.crt.pem;sslverify=1"
- cnxn = pyodbc.connect(connection_string)
- import mysql.connector
- cnx = mysql.connector.connect(user="{username@servername}", password="{password}",
- host="{server_name}.mysql.database.azure.com",
- port=3306, database="{database_name}", ssl_ca="/home/sachin//root.crt",
- ssl_verify_cert=True)
- cnx.cursor()
Add Comment
Please, Sign In to add comment