P
Prisma•7mo ago
darkTower

Where is my environment var coming from?

Odd question but I recently changed my SQL provider. In my deployed environment I have an environment var called DATABASE_URL it works fine I updated it and now in my deployed environment I'm pointing to the correct server. In my local host though I have no idea where DATBASE_URL is getting set. I don't have a .env file. I did this 5 months ago but I know I didn't want my database info in my repo. It would make sense that I would create an environment var in my localhost only I don't remember doing so and when I type printenv DATABASE_URL isn't listed. That said when I build my app I get an error saying it can't connect to my old provider so it's getting it from somewhere I have the following in my schema but no idea where I set it - anyone have any ideas? 
datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}
datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}
1 Reply
RaphaelEtim
RaphaelEtim•7mo ago
Hi @darkTower 👋 Do you by any means have DATABASE_URL hard coded in your code? Are you using Docker? If you are using Docker or any containerization tool, the environment variable might be set in a Dockerfile, Docker Compose file. You may also want to search for DATBASE_URL in your local environment files by using this command in the terminal 
grep -r "DATABASE_URL" .
grep -r "DATABASE_URL" .

Did you find this page helpful?