Prisma connection to remote mySql fails unless unlimited access allowed

Support
1

Site name: effulgent-palmier-626308
Custom domain: enviopest.org
Error:
Runtime.UnhandledPromiseRejection - Error: Authentication failed against database server at 66.198.240.11, the provided database credentials for godsgif1_demo are not valid. Please make sure to provide valid database credentials for the database server at 66.198.240.11.

I use A2Hosting for a mySql database. If I add Remote Access Host wildcard “%” , I connect just fine. But I certainly don’t want to do that. Is there an IP address I can use, instead, to allow Netlify or Prisma - whatever it is that makes the connection - access to the database?

2

Unfortunately not. Netlify Functions run on AWS Lambda and the IP Addresses are dynamically allocated.