Create MySQL Database Login Page in Python using Tkinter

Create MySQL Database Login Page in Python using Tkinter

Creating a MySQL database login page using Python involves multiple steps:

  1. Setting up MySQL: Make sure you have MySQL installed and running. Create a database and a table for storing user credentials (for the sake of this example).
  2. Backend Logic: You'll need a Python library to communicate with MySQL. The most commonly used one is mysql-connector-python.
  3. Frontend Logic: For the graphical user interface (GUI), we'll use Tkinter.

Let's break it down step by step.

1. MySQL Setup:

For the purpose of this example, let's assume you have a database named users_db and a table named users with columns username and password.

2. Backend Logic:

Install the required package:

pip install mysql-connector-python

3. Frontend Logic:

Let's create a simple login page with Tkinter:

import tkinter as tk
from tkinter import messagebox
import mysql.connector

def check_login():
    username = username_var.get()
    password = password_var.get()
    
    connection = mysql.connector.connect(host='localhost',
                                         database='users_db',
                                         user='root',   # Replace with your MySQL username
                                         password='')   # Replace with your MySQL password
    cursor = connection.cursor()
    cursor.execute(f"SELECT * FROM users WHERE username='{username}' AND password='{password}'")
    row = cursor.fetchone()
    
    if row:
        messagebox.showinfo("Info", "Login Successful")
    else:
        messagebox.showerror("Error", "Invalid Credentials")
    
    cursor.close()
    connection.close()

# GUI
root = tk.Tk()
root.title("MySQL Login")

username_var = tk.StringVar()
password_var = tk.StringVar()

tk.Label(root, text="Username").pack(pady=10)
tk.Entry(root, textvariable=username_var).pack(pady=10)

tk.Label(root, text="Password").pack(pady=10)
tk.Entry(root, textvariable=password_var, show='*').pack(pady=10)

tk.Button(root, text="Login", command=check_login).pack(pady=20)

root.mainloop()

This code sets up a basic Tkinter window with fields for username and password. When the login button is pressed, it checks the MySQL users table in the users_db database to validate the credentials.

Note: For actual applications, avoid storing passwords in plain text. Always use proper hashing and salting techniques like bcrypt. Also, avoid using string formatting directly for SQL queries; it can lead to SQL injection. Use parameterized queries instead.

More Tags

aws-step-functions debugging graphicsmagick entities typesetting eventtrigger struct domain-driven-design zipline postgresql-11

More Programming Guides

Other Guides

More Programming Examples