# www.plus2net.com
# download updated script at https://www.plus2net.com/python/tkinter-mysql.php
import mysql.connector
import tkinter as tk
from tkinter import *
my_w = tk.Tk()
my_w.geometry("400x250")
my_connect = mysql.connector.connect(
host="localhost",
user="root",
passwd="your_password_here",
database="my_tutorial"
)
####### end of connection ####
my_cursor = my_connect.cursor()
my_cursor.execute("SELECT * FROM student limit 0,10")
i=0
for student in my_cursor:
for j in range(len(student)):
e = Entry(my_w, width=10, fg='blue')
e.grid(row=i, column=j)
e.insert(END, student[j])
i=i+1
my_w.mainloop()