Drizzle Team•9mo ago

Having issue connecting to mysql hosted in AWS

I am trying to connect to a mysql database hosted on AWS but i am getting an error that my connection strings are not correct or something but the same details work when I use DBeaver to view my database. Can someone help with this question? I am totally new to drizzle

7 Replies

Ali SultaniOP•9mo ago

Mykhailo•9mo ago

Hello, @Ali Sultani! I think you should use only uri or only

{
        host: string;
        port?: number;
        user?: string;
        password?: string;
        database: string;
}

{
        host: string;
        port?: number;
        user?: string;
        password?: string;
        database: string;
}

for db credentials

Ali SultaniOP•9mo ago

I tried that too but still won't work

Mykhailo•9mo ago

Could you please console log the credentials?

Ali SultaniOP•9mo ago

Yeah they show up in the console Maybe drizzle doesn't support mysql hosted on AWS?

Mykhailo•9mo ago

Strange, drizzle should support it. Am I right that you are using AWS RDS?

Ali SultaniOP•9mo ago

Hey @solo thanks for your help. It turned out to be the dotenv variables after all frickin dotenv

Gaming

Programming

Having issue connecting to mysql hosted in AWS