# 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()