I have a frontend and a MySQL database running on a specific host. My backend is running on render, it is a node.js application that uses prisma to manage connections.
Using a localhost, I’m able to access the data. I have added an access host which regards my PC IP in cPanel and it works fine. However, when I try to access from render it returns an error:
“Authentication failed against database server at
0.0.0.0 (some IP), the provided database credentials for
user are not valid.”
I have set an environment variable with general model (I’m using pseudonyms here for exemplification):
Now I’m wondering:
Should I set an IP regarding render app?
What’s wrong with my procedure?
Is there another way to set the environment variable?
Can anybody help me with this questions?