Search code examples
mysqldatabaseamazon-web-servicesaws-lambdaamazon-rds

Why I can not see database in AWS RDS MySQL?

I am working on a project where I am supposed to run a python script (using AWS Lambda) once in 24 hours and whatever data is collected during the run that will be stored in AWS RDS MySQL database.

I have created a database identifier in RDS. Later, using jupyter notebook, I created the database in the same database identifier.

My problem is that I am able to read, write to/from the database and perform all possible operations on the database. However, when I open AWS RDS, anywhere I am unable to see the database that I've created!

in DB Name, it is blank, though the database exists!

I did some google, and found that it is maybe due to the region is set to a different area. I checked for those possibilities too. Still, I have no idea why it is happening?

Also, when I click on "Query Editor" in AWS RDS, it prompts me to create the database. But the database is already there and also contains the data!!! It is just that I can not see that!

enter image description here

What possibly could be wrong here?

Solution

  • As you can see in their press release, RDS Query editor for Aurora is currently available only on Serverless databases.

    You could try converting your DB to Serverless (this answer provides very useful tips to do so). But as your project seems to be brand new, you're probably better off creating a brand new Aurora Serverless DB, as described in those AWS docs. Good luck!