Drizzle Team•2y 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•2y ago

Mykhailo•2y 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•2y ago

I tried that too but still won't work

Mykhailo•2y ago

Could you please console log the credentials?

Ali SultaniOP•2y ago

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

Mykhailo•2y ago

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

Ali SultaniOP•2y 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

Did you find this page helpful?