Guest User

Untitled

a guest
Dec 18th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. connection_string = "DRIVER={MySQL};SERVER={server_name}.mysql.database.azure.com;PORT=3306;DATABASE"
  2. "={my_database_name};UID={username@server_name};PWD={password};CHARSET=UTF8;"
  3. "sslca=/home/sachin/BaltimoreCyberTrustRoot.crt.pem;sslverify=1"
  4. cnxn = pyodbc.connect(connection_string)
  5.  
  6. import mysql.connector
  7.  
  8. cnx = mysql.connector.connect(user="{username@servername}", password="{password}",
  9. host="{server_name}.mysql.database.azure.com",
  10. port=3306, database="{database_name}", ssl_ca="/home/sachin//root.crt",
  11. ssl_verify_cert=True)
  12. cnx.cursor()
Add Comment
Please, Sign In to add comment