I am trying to create my first tables on my RDS database. I have successfully setup, connected to an EC2 processor and able to connect and run queries in MySQL Workbench but when I try to create tables I run into an issue.

This is my first time using both RDS and MySQL Workbench so likely a programmer error.

I tried to run my CREATE command and received the following error:

Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.
'

When I use SHOW DATABASES I get 4 rows: information_schema, mysql, performance_schema and sys None of which match my RDS instance name.

I tried USE sys and mysql and when I try to run the CREATE commands on either of those databases I get the error:

Error Code: 1044. Access denied for user 'myusername'@'%' to database 'mysql'

Here is the information under the database I have created on RDS in the Configuration tab, I noticed the DB name is null:

Configuration
DB instance ID
test-referrals
Engine version
8.0.35
RDS Extended Support
Disabled
DB name
-
License model
General Public License
Option groups
default:mysql-8-0
In sync

I don’t see a way to add or edit the DB name. Is this the cause of my problems? If not, how do I connect to my RDS database instance using MySQL Workbench?

Any suggestions on how to connect and create my tables?

Have tried renaming the instance ID, however the instance ID only allows alphanumeric and hyphens, when I try to use this name in my USE command I get a syntax error at the hyphen.