MySQL Grant & Java Servlet Session Management Assignment | Part A & B Demonstration by Group 8

This video demonstrates the complete solution to my MySQL and Java Servlet session management assignment, covering both Part A and Part B. ✅ Part A – MySQL User & Table Permissions: • Created a MySQL user 'Sehdev_Singh'@'localhost' • Granted INSERT and SELECT privileges on a single schema and table (Assign2_sehdevsingh.Signup) • Tested access and verified using SHOW GRANTS • Revoked INSERT permission and confirmed expected failure ✅ Part B – Java Servlet Session Handling: • Used FirstServlet to create and invalidate sessions • Tested setting attributes (name, email, age) before and after invalidation • Passed email to SecondServlet and confirmed session behavior • Applied session timeout (setMaxInactiveInterval) for 180 seconds • Removed the 'age' attribute after accessing it in SecondServlet 🎓 This video was created as part of my assignment submission for the Web Application Development / Java Servlets course. 🎬 Tools used: • MySQL Workbench 8.0 • Eclipse IDE 2025-06 • Apache Tomcat 10.1 • Java Servlets (Jakarta EE) 📌 By Rahuldas, Abhishek, Sehdev Singh 📅 Recorded: 22 June 2025 #MySQL #JavaServlet #SessionManagement #WebAppAssignment #ServletSession #Comp3026 #Tomcat #EclipseIDE #MySQLGrant #JakartaEE