To Create login Username and Password Storage in Mysql Database

When building a secure application, user authentication is a top priority. One of the essential steps is creating a login username and password storage system in MySQL. This tutorial will guide you through setting up a simple authentication table and inserting sample user credentials.

Steps to Create Login Username and Password Storage in MySQL

1. Create a Table for Authentication
   Use the following SQL query to create a table that stores usernames and passwords:
   
   CREATE TABLE tbl_auth_user (
   user_id VARCHAR(10) NOT NULL,
   user_password CHAR(32) NOT NULL,
   PRIMARY KEY (user_id)
   );

2. Insert User Credentials
   Add login usernames and encrypted passwords using the PASSWORD() function:
   
   INSERT INTO tbl_auth_user (user_id, user_password) VALUES (‘theadmin’, PASSWORD(‘chumbawamba’));
   
   INSERT INTO tbl_auth_user (user_id, user_password) VALUES (‘webmaster’, PASSWORD(‘webmistress’));