🌐
AWS re:Post
repost.aws › questions › QUZH4Tg-xEQbO_lMmn2cvpqQ › how-to-connect-to-aws-rds-mysql-instance-from-my-laptop
How to Connect to AWS RDS (MySQL) Instance from My Laptop? | AWS re:Post
January 5, 2023 - Consider having DB on private subnets and use bastion with SSMto access (https://aws.amazon.com/premiumsupport/knowledge-center/rds-connect-ec2-bastion-host/) ... How to access a public RDS instance from lambda without compromising on the security of RDS by putting an inbound rule for RDS Sg with source as 0.0.0.0/0 ? ... My RDS instance has an inbound rule specifically allowing my Fargate Security Group, but I can't connect. ... How do I use Amazon RDS Proxy to connect to my Amazon RDS for MySQL DB instance or Aurora MySQL-Compatible DB cluster?
🌐
AWS
aws.amazon.com › databases › amazon rds › amazon rds for mysql
Hosted MySQL - Amazon RDS for MySQL - AWS
1 day ago - Amazon RDS for MySQL, the relational database service that makes it easy to set up, operate, and scale MySQL deployments in the cloud.
Discussions

Help choosing a MySQL RDS size for huge traffic spike next week
Are these spikes approximately the same size every time they happen? Do you run out of disk burst balance? Do you run out of DB connections? Do you have a load testing suite you can aim at your DB to generate load? Is the DB your bottleneck or are there other bottlenecks too? I'd start with the m5* family. They aren't burstable but have held up well for my workloads. The m6g, using Graviton is substantially cheaper than the amd64 based instances. I've seen 40% cheaper, which almost the next instance size up for free. The r* and x* families are if you need tons of RAM. You mentioned that the CPU is what maxes out, not RAM. I agree with your assessment to avoid those. You probably don't have time to do this but.... evaluate which SQL calls you're making and which one's are really expensive or really high volume. RDS Performance Insights is amazing for this kind of troubleshooting. It's possible that some of your queries can be pushed off to a memcache or Redis instance. If so, that's a set of queries that don't go to the DB anymore and you've got that much more headroom for DB CPU and Disk IOPs. More on reddit.com
🌐 r/aws
19
1
February 28, 2021
Slow queries to AWS RDS MySQL Database

You might want to try something like django-query-inspect (https://github.com/dobarkod/django-queryinspect). Django rest framework will make a lot of additional calls if you have nested serializers, etc, that aren't always obvious. If you find that this is the case, prefetch_related and select_related will really help get your query count down.

More on reddit.com
🌐 r/django
6
5
June 29, 2013
MySQL RDS - Streaming binlog with kinesis (CDC & processing)
Amazon just announced support in in the Database Migration service to replicate to Kinesis: https://aws.amazon.com/blogs/database/use-the-aws-database-migration-service-to-stream-change-data-to-amazon-kinesis-data-streams/ Can I ask though why you can't just use the built in MySQL replication? More on reddit.com
🌐 r/aws
1
6
June 4, 2018
RDS: mysql -> aurora migration stuck in "preparing-data-migration"
If your source is RDS MySQL, then you could convert using a snapshot. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.RDSMySQL.Import.html More on reddit.com
🌐 r/aws
6
4
January 14, 2020
People also ask

What Is Amazon RDS?
Amazon RDS, or Relational Database Service, is a cloud-based database service provided by Amazon Web Services (AWS). It simplifies the setup, operation, and scaling of relational databases, offering support for various database engines like MySQL, PostgreSQL, Oracle, and SQL Server.
🌐
blog.dreamfactory.com
blog.dreamfactory.com › amazon-rds-vs-mysql
Amazon RDS vs. MySQL | How to Choose What is Best For You
How Does Amazon RDS Work?
Amazon RDS automates many database management tasks. Users choose their preferred database engine, specify resource requirements, and RDS handles the rest, including software patching, backups, and maintenance. It offers high availability, failover, and scalability features.
🌐
blog.dreamfactory.com
blog.dreamfactory.com › amazon-rds-vs-mysql
Amazon RDS vs. MySQL | How to Choose What is Best For You
What Is MySQL?
MySQL is an open-source relational database management system (RDBMS) known for its speed and reliability. It's widely used for storing and managing structured data, from small web applications to large-scale enterprise systems.
🌐
blog.dreamfactory.com
blog.dreamfactory.com › amazon-rds-vs-mysql
Amazon RDS vs. MySQL | How to Choose What is Best For You
🌐
Amazon Web Services
docs.aws.amazon.com › amazon rds › user guide › amazon rds for mysql › mysql on amazon rds versions
MySQL on Amazon RDS versions - AWS Documentation
For example, the following AWS CLI command returns the default MySQL minor engine version for the 5.7 major version and the US West (Oregon) AWS Region (us-west-2): aws rds describe-db-engine-versions --default-only --engine mysql --engine-version 5.7 --region us-west-2 --query "*[].{Engine:Engine,EngineVersion:EngineVersion}" --output text
🌐
Medium
ajitfawade.medium.com › how-to-use-amazon-rds-to-set-up-and-manage-mysql-databases-in-aws-a-complete-guide-for-devops-4a8d132aabf9
How to Use Amazon RDS to Set Up and Manage MySQL Databases in AWS: A Complete Guide for DevOps…
November 15, 2023 - Are you a DevOps learner who wants to use Amazon Relational Database Service (Amazon RDS) to set up and manage MySQL databases in AWS? If yes, then this blog post is for you. In this post, I’ll explain what Amazon RDS is and how to use it to create, configure, and connect to MySQL databases in the cloud.
Amazon Relational Database Service (or Amazon RDS) is a distributed relational database service by Amazon Web Services (AWS). It is a web service running "in the cloud" designed to simplify the setup, … Wikipedia
Factsheet
Developer Amazon.com
Initial release October 26, 2009; 16 years ago (2009-10-26)
Operating system Cross-platform
Factsheet
Developer Amazon.com
Initial release October 26, 2009; 16 years ago (2009-10-26)
Operating system Cross-platform
Find elsewhere
🌐
AWS
aws.amazon.com › products › databases › amazon rds
Managed SQL Database - Amazon Relational Database Service (RDS) - AWS
2 days ago - Amazon Relational Database Service (RDS) is a fully managed, open-source cloud database service that allows you to easily operate and scale your relational database of choice, including Amazon Aurora, PostgreSQL, SQL Server, and MySQL.
🌐
Amazon Web Services
docs.aws.amazon.com › amazon rds › user guide › getting started with amazon rds › creating and connecting to a mysql db instance
Creating and connecting to a MySQL DB instance - Amazon Relational Database Service
3 weeks ago - In the upper-right corner of the Amazon RDS console, choose the AWS Region you used for the EC2 instance previously. In the navigation pane, choose Databases. Choose Create database and make sure that Easy create is chosen. In Configuration, choose MySQL.
🌐
DreamFactory
blog.dreamfactory.com › amazon-rds-vs-mysql
Amazon RDS vs. MySQL | How to Choose What is Best For You
May 7, 2024 - It allows users to easily set up, operate, and scale relational databases without the need for extensive manual management. Amazon RDS supports various database engines, including MySQL, Oracle, and Microsoft SQL Server. Amazon RDS works by ...
🌐
Amazon Web Services
docs.aws.amazon.com › amazon rds › user guide › amazon rds for mysql › mysql feature support on amazon rds
MySQL feature support on Amazon RDS - Amazon Relational Database Service
MySQL major versionsSupported storage enginesUsing memcached and other optionsInnoDB cache warmingInclusive language changes for MySQL 8.4Features not supported · RDS for MySQL supports most of the features and capabilities of MySQL.
🌐
DEV Community
dev.to › gbenga700 › create-and-connect-to-a-mysql-database-with-amazon-rds-131o
Create and Connect to a MySQL Database with Amazon RDS - DEV Community
December 12, 2023 - Amazon RDS supports MySQL Community Edition versions 5.7 and 8.0 which means that the code, applications, and tools you already use today can be used with Amazon RDS. ... Easy, managed deployments: It takes only a few clicks in the AWS Management ...
🌐
AWS
docs.aws.amazon.com › aws hands-on tutorials › hands-on tutorials › create and connect to a mysql database with amazon rds
Create and Connect to a MySQL Database with Amazon RDS - Create and Connect to a MySQL Database with Amazon RDS
In this tutorial, you will learn how to create an environment to run your MySQL database (we call this environment an instance), connect to the database, and delete the database instance. We will do this using Amazon Relational Database Service (Amazon RDS) ... An AWS account: If you don't ...
🌐
NetApp
netapp.com › home › blog › aws-cvo-blg-aws-mysql-two-ways-to-enjoy-mysql-as-a-service
AWS MySQL: MySQL as a Service vs. Self Managed in the Cloud | NetApp
January 27, 2021 - There are several options for running MySQL databases as a service on the Amazon cloud. AWS RDS lets you run a managed database instance, taking care of administrative tasks like scalability, backups and high availability.
🌐
Fivetran
fivetran.com › docs › connectors › databases › mysql › rds-setup-guide
Amazon RDS for MySQL database connector by Fivetran | Setup Guide
CREATE USER '<username>'@'%' IDENTIFIED WITH mysql_native_password BY '<password>'; For IAM authentication, execute the following SQL command. Replace <username> with a username that matches the {db-user-name} from Step 2. CREATE USER '<username>'@'%' IDENTIFIED WITH AWSAuthenticationPlugin AS 'RDS';
🌐
End of Life Date
endoflife.date › amazon-rds-mysql
Amazon RDS for MySQL | endoflife.date
November 21, 2025 - Amazon RDS for MySQL is a PaaS offering from Amazon for creating managed MySQL Community Edition databases. RDS makes it easier to set up, operate, and scale MySQL deployments on AWS cloud.
Top answer
1 of 6
10

When you create you create your RDS instance, there is an “Additional configuration” section, in which you can specify the database name, and it warns you that if no name is provided, no database will be created by default.

But as others have pointed out, you can connect with your tool of choice without a database name, perform a CREATE DATABASE xxx; where xxx is the name of the database, and then use can use that database going forward.

2 of 6
8

The name that you circled in the second screenshot is not a mysql database name, it's merely an identifier how your database instance is known as in AWS, i.e. endpoint name. These may be different!

Since logging in without specifying the MySQL database name works it means your connectivity and credentials are correct. You can't create tables because you didn't select a database where to create these tables.


So why can't you connect with a database name specified?

I suspect your default database name that was created by AWS when setting up the RDS instance isn't prueba but something else. You should be able to figure that you in the RDS Details tab:

Note that my Endpoint Name is prueba but the MySQL Database Name is something.

I can login to the RDS and list the databases:

~ $ mysql -h prueba.xxxxxxxxxx.ap-southeast-2.rds.amazonaws.com -uroot -p
Enter password: 
Server version: 5.6.40 Source distribution

MySQL [(none)]> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| innodb             |
| mysql              |
| performance_schema |
| something          |      <<<< Here is my "default" database
| sys                |
+--------------------+
6 rows in set (0.04 sec)

So to wrap it up - you'll have to figure out your actual mysql database name:

  • find out what was the default database name that you specified when creating the instance from the RDS Details screen, or
  • find out the database name by logging in without a db name specified and then run SHOW DATABASES;, or
  • create a new one using CREATE DATABASE whatever; or using some dialog in your DB tool.

Once you've got the database name you can then connect to it in your connect dialog or with USE whatever; and then you can finally create your tables.

Hope that helps :)

🌐
Hevodata
docs.hevodata.com › sources › dbfs › databases › mysql › amazon-rds-mysql
Amazon RDS MySQL - Hevo Data
You can ingest data from your Amazon RDS MySQL database using Hevo Pipelines and replicate it to a Destination of your choice. Hevo recommends connecting to a read-replica of your master MySQL database, however, this is not mandatory. A read-replica reflects the changes to your master database in near real-time, and can reduce the load on the master database by serving all “read” requests.
🌐
AWS re:Post
repost.aws › knowledge-center › rds-mysql-server-activity
View server activity for an Amazon RDS for MySQL DB instance | AWS re:Post
November 9, 2022 - ON r.trx_id = w.requesting_engine_transaction_id;INNER JOIN information_schema.innodb_trx r ON b.trx_id = w.blocking_engine_transaction_id INNER JOIN information_schema.innodb_trx b FROM performance_schema.data_lock_waits w b.trx_query blocking_query b.trx_mysql_thread_id blocking_thread, b.trx_id blocking_trx_id, r.trx_query waiting_query, r.trx_mysql_thread_id waiting_thread, r.trx_id waiting_trx_id, Note: It's a best practice to gather these outputs at short, consecutive intervals (for example, 60 seconds). Reviewing multiple outputs can provide a broader view of the state of the engine. This helps you troubleshoot problems with performance. ... What license program do I select to activate AWS RDS per call licensing on Server 2022?
🌐
AWS
aws.amazon.com › databases › amazon rds › pricing
Managed Relational Database - Amazon RDS Pricing - Amazon Web Services
2 days ago - If you signed up for AWS Free Tier prior to July 15, 2025, you can continue to use RDS for free for up to 12 months on select single-AZ instance databases with up to 750 hours per month. Your usage is aggregated across instance types if using more than one instance. (Available engines: MySQL, MariaDB, PostgreSQL, or SQL Server – SQL Server Express Edition only.)
🌐
AWS
aws.amazon.com › databases › amazon rds › instance types
Amazon RDS Instance Types | Cloud Relational Database | Amazon Web Services
2 days ago - Powered by the AWS Nitro System, a combination of dedicated hardware and lightweight hypervisor · All instances have the following specs: Up to 4.0 GHz Intel® Xeon® Scalable Processors · Intel AVX, Intel AVX2, Intel Turbo · EBS Optimized · Enhanced Networking · X2g instances are optimized for high-performance databases. X2g instances offer the lowest price per GiB of RAM among Amazon RDS instance types for MySQL, MariaDB, and PostgreSQL databases.