🚀 User Management System
A simple and secure User Management Web Application built using Node.js, Express, EJS, and MySQL. This project allows you to manage users with features like adding, updating, and deleting users with proper verification.
📌 Features ➕ Add new users ✏️ Rename (update username) with password verification ❌ Delete users using email & password verification 📊 Home page showing total number of users 📄 User list page with edit & delete options 🔐 Basic authentication for sensitive actions 🛠️ Tech Stack
Backend: Node.js, Express.js Frontend: EJS (Embedded JavaScript Templates) Database: MySQL Other: Method-Override, UUID
📁 Project Structure project/ │ ├── views/ # EJS templates ├── public/ # Static files (CSS, JS) ├── routes/ # Route handlers ├── models/ # Database queries (if used) ├── app.js # Main server file └── package.json
Setup MySQL Database
Create a database and run:
CREATE TABLE user ( id VARCHAR(50) PRIMARY KEY, username VARCHAR(50) UNIQUE, email VARCHAR(50) UNIQUE NOT NULL, password VARCHAR(50) NOT NULL ); Start the server node app.js Open in browser http://localhost:8080 🖥️ Pages & Functionality 🏠 Home Page Displays total number of users “Join” button to add a new user
📋 User List Page Shows all users Two actions: ✏️ Edit Username ❌ Delete User ✏️ Rename User
Opens a form Takes: New Username Password If password is correct → username is updated ❌ Delete User Opens a form Takes: Email Password
If credentials are correct → user is deleted Redirects back to user list page
🔐 Security Note Password verification is implemented before: Updating username Deleting user ⚠️ Currently passwords are stored in plain text (for learning purpose);
🙌 Author Nikhil Verma
site is live at https://nikhilverma56.github.io/user-management-system/