DotEnv error while contectin to data base

Question

The problem is simple, but i dont know if the think i am doing is wrong, i will try to explain it and if some knows how to solve it wold be cool and i will thank you so much.

1. remember that this app is made whit NextJS

2. DotEnv variables are in a .env file that is in the root folder of my NextJs app.

3. I have this data base connection where i am using DotEnv variables:

** UPDATE **

i am not destructuring more the data according to the NextJs documentation, and now my .env is .env.local and still not working, if someone knows why it is not working you are free to comment.

       const db = mysql({  
            config: {    
                host: process.env.MYSQL_HOST ,    
                port: process.env.MYSQL_PORT , 
                database: process.env.MYSQL_DATABASE , 
                user: process.env.MYSQL_USER ,  
                password: process.env.MYSQL_PASSWORD 
              }
       });  
       

by this way it is supposed to connect but it give me an access error to the database, but when i place the data like this without DotEnv.

const db = mysql({  
          config: {    
               host: "127.0.0.1" ,    
               port: 3306 , 
               database: "mydatabase" , 
               user: "myuser" ,  
               password: "123" 
         }
    });

the connection works fine. may be its the way i am declarating my .env file ore somthing, if you know what am I doing wrong I would be glad to know. thaks for reading.

Answer 1

I've fallen into the same trap; Next handles environmental variables that are stored on .env.local files, rather than .env; So to retrieve them, you'll simply need to rename your file

Docs: https://nextjs.org/docs/basic-features/environment-variables

Edit

Found the gotcha - From the docs:

Note: In order to keep server-only secrets safe, Next.js replaces process.env.* with the correct values at build time. This means that process.env is not a standard JavaScript object, so you’re not able to use object destructuring. Environment variables must be referenced as e.g. process.env.NEXT_PUBLIC_PUBLISHABLE_KEY, not const { NEXT_PUBLIC_PUBLISHABLE_KEY } = process.env.

So aside from renaming your file to .env.local, make sure to also call your variables as process.env.VAR_NAME instead of destructuring