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

1 vote187 views1 answer
Vagrant mysql downgrade version
SQL
-1 vote238 views1 answer
MYSQL stored procedure select from
SQL
0 vote213 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
2 votes206 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote218 views1 answer
Mysql limit order by
SQL
-2 votes194 views1 answer
Mysql see users and passwords
SQL
1 vote194 views1 answer
Oracle convert run duration to number
SQL
0 vote179 views1 answer
Grant access on table in oracle
SQL
-1 vote182 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote183 views1 answer
Sql find all different values in column
SQL