Mysql connection python

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

27 votes142 views3 answers
How to draw in pygame
Python
0 vote117 views1 answer
Snapchat api in python
Python
3 votes122 views2 answers
Encryption using python
Python
0 vote145 views2 answers
Enumerate word python
Python
1 vote124 views1 answer
Conda python 3.8
Python
0 vote159 views1 answer
Customise the django rest api view
Python Django
0 vote119 views1 answer
How to print keys and values of dictionary together in python?
Python
120 votes122 views6 answers
Getting Input in Python
Python
43 votes143 views1 answer
Python liste alphabaet
Python
2 votes93 views1 answer
Python maths max value capped at x
Python