forum

home / developersection / forums / python mysql create database

Ask Question

Python MySQL Create Database

Anonymous User 1225 09-Jul-2018

How to Create Database MySQL in Python ?

python-3.4 python

Updated on 09-Jul-2018

Anonymous User

Other

I am a content writter !

Follow Message

Can you answer this question?

Answer

1 Answers

Prakash nidhi Verma

09-Jul-2018

Python needs a MySQL driver to access the MySQL database.

In this tutorial we will use the driver "MySQL Connector".

We recommend that you use PIP to install "MySQL Connector installation of mysql connector :

C:\Users\Your Name\AppData\Local\Programs\Python\Python36-32\Scripts>python -m pip install mysql-connector

DataBase connector import in system :

import mysql.connector

example :

mydb = mysql.connector.connect( 
  host="localhost",

  user="yourusername",

  passwd="yourpassword"

)

mycursor = mydb.cursor()


mycursor.execute("CREATE DATABASE mydatabase")

forum

Python MySQL Create Database

Anonymous User

Can you answer this question?

1 Answers

Liked By