I am new to AWS. I have a confusion which I want to figure out. My question is: Can we create multiple databases on a single Amazon RDS Aurora DB Instance? by simply connecting to the database engine using root credentials and querying "CREATE TABLE IF NOT EXISTS" command?

Hope I am much clear about my question. Further, Please guide if there is any other option to achive defined functionality.

TIA.

CodePudding user response：

Based on the comments.

You create extra databases using SQL. Once you connect to your Aurora RDS, either MySQL or PostgreSQL, using mysql or psql clients (or other client), you can use SQL to create new databases:

• MySQL: CREATE DATABASE Statement
• PostgreSQL: CREATE DATABASE