1) Create table CREATE TABLE `dbname`.`login` ( `id` int(11) NOT NULL auto_increment, `userid` varchar(50) default NULL, `password` varchar(50) default NULL, `Role` varchar(200) default NULL, KEY `id` (`id`) ) 2) Insert Values into table ID USER-ID PASSWORD ROLE 1 Admin Admin@123456 Admin 2 Pratibha pratibha@123 Agent 3 Rohan rohan@123 Agent 4 User User@123 Customer