Creating an RDS for MySQL Instance

Updated on 2022-09-15 GMT+08:00

View PDF

Create an RDS for MySQL instance and test data.

Creating an RDS for MySQL Instance

Log in to the .
Click in the upper left corner and select region EU-Dublin.
Click the service list icon on the left and choose Databases > Relational Database Service.
Click Buy DB Instance.
Configure the instance name and basic information.
Select an instance class.
Select a VPC and security group and configure the database port.

The VPC and security group have been created in Creating a VPC and Security Group.
Set the instance password.
Click Next and complete the whole process.
Return to the instance list.

If the instance status becomes Available, the instance is created.

Creating Test Data

Log in to the .
Click in the upper left corner and select region EU-Dublin.
Click the service list icon on the left and choose Databases > Relational Database Service.
Locate the created RDS instance and choose More > Log In.
In the displayed dialog box, enter the username and password of the instance and click Test Connection.
After the connection is successful, click Log In.
Click Create Database to create the db_test database.

Run the following SQL statement in db_test to create table table3_:

CREATE TABLE `db_test`.`table3_` (
	`Column1` INT(11) UNSIGNED NOT NULL,
	`Column2` TIME NULL,
	`Column3` CHAR NULL,
	PRIMARY KEY (`Column1`)
)	ENGINE = InnoDB
	DEFAULT CHARACTER SET = utf8mb4
	COLLATE = utf8mb4_general_ci;

Run the following statements in table table3_ to insert three lines of data:

INSERT INTO `db_test`.`table3_` (`Column1`,`Column2`,`Column3`) VALUES(1,'00:00:11','a');
INSERT INTO `db_test`.`table3_` (`Column1`,`Column2`,`Column3`) VALUES(2,'00:00:22','b');
INSERT INTO `db_test`.`table3_` (`Column1`,`Column2`,`Column3`) VALUES(5,'00:00:55','e');