Python and mysql connectivity

Connect python to mysql

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)

Python and mysql connectivity

import pymysql

############### CONFIGURE THIS ###################
# Open database connection
db = pymysql.connect("database_host","username","password","database_name")
##################################################

# prepare a cursor object using cursor() method
cursor = db.cursor()

# execute SQL query using execute() method.
cursor.execute("SELECT VERSION()")

# Fetch a single row using fetchone() method.
data = cursor.fetchone()
print ("Database version : {0}".format(data))

# disconnect from server
db.close()

Source: copitosystem.com

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)

Similar codes

10 votes144 views6 answers
Between sql
SQL
1 vote134 views1 answer
Postgres killing connections on db
SQL
0 vote133 views1 answer
Get who is hired in specific month in sql
SQL
0 vote132 views1 answer
Is not null postgresql
SQL
2 votes137 views1 answer
Cast string to datetime mysql
SQL
0 vote146 views1 answer
Mysql url data type
SQL
0 vote143 views1 answer
Stored function in sql
SQL
5 votes95 views1 answer
Mongodb vs
SQL
0 vote90 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote171 views1 answer
Mysql best varchar length size
SQL