How to connect with MySQL using Python

import mysql.connector
cn = mysql.connector.connect(
    user='root',
    password='',
    host='localhost',
    database='test'
    )
command = cn.cursor()
myquery = ("SELECT * FROM student")
command.execute(myquery)

Comments