Hey everyone, I had a question about connecting to remote sql or mariadb instance, I was wondering how you typically format your connector. Right now I am getting a connection error and I believe it's trying to connect locally even though I have a hosting ip indicated. Any assistance would be great.
r
Ryan
03/18/2021, 7:21 AM
@Daniel Snell👋
Are you using an
.env
file to set your connection string?
d
Daniel Snell
03/18/2021, 9:42 AM
@Ryan yes, my db connection requires ssh tunnel and I couldn't find documentation on that is it not supported with Prisma?
r
Ryan
03/18/2021, 9:46 AM
Yes it is. You can map your remote DB to localhost and connect it to Prisma. I have done the same in this post under the SSH forwarding section.
d
Daniel Snell
03/18/2021, 12:44 PM
@Ryan thank you i will check that out and give it a go! Also do I use sql in connection string for mariadb or is there a seperate one?