connect database in python

connect to sql server with python

import pyodbc 
# Some other example server values are
# server = 'localhostsqlexpress' # for a named instance
# server = 'myserver,port' # to specify an alternate port
server = 'tcp:myserver.database.windows.net' 
database = 'mydb' 
username = 'myusername' 
password = 'mypassword' 
cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
cursor = cnxn.cursor()

#Sample select query
cursor.execute("SELECT @@version;") 
row = cursor.fetchone() 
while row: 
    print(row[0])
    row = cursor.fetchone()

Posted by: Guest on February-24-2020

Source

import mysql.connector cnx = mysql.connector.connect(user='scott', password='password', host='127.0.0.1', database='employees') cnx.close()

import mysql.connector mydb = mysql.connector.connect( host="localhost", user="yourusername", password="yourpassword", port = 8888, #for Mamp users database='whatever db you want' ) print(mydb)

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)

Code answers related to "connect database in python"

Browse Popular Code Answers by Language

Answers for "connect database in python"

Code answers related to "connect database in python"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us