Learning Objective:

• In this lesson, we will learn to add mysql constants.

Task 1: Add MySQL Credentials in .env file

    DB_HOST=localhost    
    DB_USERNAME=root
    DB_PASSWORD=root
    DB_DATABASE_NAME=bankapp_db
    DB_PORT=3306
    NO_OF_CONNECTIONS=10

Task 2: Replace Hard coded data

• Existing

    const pool = mysql.createPool({
            host: "localhost",
            port: 3306,
            user: "root",
            password: "root",
            database: "training_db",
            connectionLimit: 10
    });

• To

    const pool = mysql.createPool({
            host: process.env.DB_HOST,
            port: process.env.DB_PORT,
            user: process.env.DB_USERNAME,
            password: process.env.DB_PASSWORD,
            database: process.env.DB_DATABASE_NAME,
            connectionLimit: process.env.NO_OF_CONNECTIONS
    });

• Note: Production credentials should not be hardcoded.

Summary

• Successfully, we have learned to manage database credentials in an environment variables.