Python with MySQL database

Introduction to Python

Collection in Python

Object Oriented python

Python With MYSQL And Excel

Python GUI

Programs in Python

Python with database

Connect Python With MySQL Database:

Python is used with database application so we can connect python with databases Here we are taking example on python with mysql database.
For this first you have to install mysql on your computer it can be installed either using mysql workbench or wamp server or xammp server etc.There are following steps to connect python with mysql database

1 Install MySql on Your Machine(if already installed no need). Then create the database with following sql query.

create database sharp_tutorial
Here username =root (it may be different on another computer)
password=root

2 Install connector of python mysql either using GUI in pycharm or using pip. For GUI install go to File—>setting –> project–>project interpreter–>pip–>search(mysql-connector) –>install

How to Connect with MySql using python.

Use the following code to to connect python with mysql database after two above steps

import mysql.connector
db=mysql.connector.connect(
host="localhost",
user="root",
password="root",
database="sharp_tutorial")
print("succecssfully connected with database")

Output: successfully connected with database(if all three steps done correctly)

Python

Java

C

C++

HTML/CSS

Java Script

PHP

SQL

C Programs

Python with database

Connect Python With MySQL Database:

Video/ C Introduction