node.js - Is there any way to use mysql workbench database in AWS lightsail through nodejs stack?

Question

I'm looking for a way to connect the Instance's database on Amazon Lightsail with MySQL Workbench remotely(from my local pc).

Pls note: I'm not looking to solve this through AWS IAM and paid database services, now I'm trying to solve these as cheaply as possible at the moment and I'm not using wordpress.

The following things that i had done.

• built a website (using html, css, js)
• hosted on AWS lightsail
• configured on linux server and with node stack
• transferred website data/code using filezilla
• Installed putty

After doing this, my website is working fine without ssh,

Now I wanted to create a login feature for students and staffs, I'm trying to enable customized user id and password for each students and staffs, so that they can access their some of their details from website.

here what I'm struggling to solve.

Using lightsail terminal I install mysql by referring this content and installed mySql workbench in my lap. I'm not sure this is a correct or not. But I wanted to connect mysql database to my aws lightsail.

If this is not possible I wonder is there are any alternative solutions as how to integrate database remotely for free. I'm new web-dev and aws, I'm willing to learn, so It would be very helpful if you can help me figure out the solution.

and I wonder without/with creating another instance on AWS is there any possibilities to create and integrate mysql database to website.

Answer 1

等待大神答复