How to create MySql...
Notifications
Clear all

How to create MySql database using Python

RSS

(@anamika)
Noble Member
Joined: 1 year ago
Posts: 1381
19/03/2021 11:12 am

I am trying to create aMySql databaseusing Python. I haveinstalled MySql connectorto my system. How can I do that?


Quote
(@abhijith)
Noble Member
Joined: 1 year ago
帖子:1350
19/03/2021 11:13 am

You need to useMySQL connectorin your python code. I have attached one example below for your reference.

import mysql.connector mydb = mysql.connector.connect( host="localhost", user="myusername", password="mypassword" ) mycursor = mydb.cursor() mycursor.execute("CREATE DATABASE mydatabase")

ReplyQuote
Share:
Baidu