This guide will explain how to use MySQL-compatible managed database service.
How Can I Use MySQL Compatible Managed Database Services?
To use MySQL compatible database, visit the RDS service from the AWS dashboard:
Click on the “Create database” button:
Select the database creation method and then select engine type as “Aurora (MySQL Compatible)”:
Select the version compatible with MySQL:
Select the template for the database and then type its name:
Enter the username and password for the database:
Configure the DB instance class:
Locate the “Connectivity” section to choose the compute resource and then select VPC for the DB cluster:
Choose the VPC security group or create a new one:
Allow the public access to connect to the RDS:
Configure the monitoring of the database:
Click on the “Create database” button:
Once the database is created, simply click on the link of its instance:
Head into the “Connectivity & security” section to copy the “Endpoint” and “Port”:
Use the following syntax to connect to the database:
Change the “Endpoint”, “Port Number”, and “Username” according to RDS credentials:
Running the above command will prompt the user to enter the password:
That’s all about using MySQL-compatible managed database service.
Conclusion
To use the MySQL-compatible managed database service, visit the RDS service from the AWS management service. Click on the “Create database” button and configure the engine compatible with MySQL. Once the database is created, simply use the endpoint and port number of the RDS to connect to it. This guide has explained the process of using MySQL-compatible managed database service.
