Python MySQL Create Database

Anonymous User 1330 09 Jul 2018

How to Create Database MySQL in Python ?

Anonymous User

Other

I am a content writter !

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

Can you answer this question?

1 Answers