Creating a MySQL DB Instance and Connecting to a Database on a MySQL DB Instance

To create a MySQL DB instance

1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

2. In the top right corner of the Amazon RDS console, select the region in which you want to create the DB instance.

3. In the navigation pane, click Instances.

4. Click Launch DB Instance. The Launch DB Instance Wizard opens on the Engine Selection page.

   

5. On the Engine Selection page, click Select for the MySQL DB engine.

6. On the DB Instance Details page, specify your DB instance information. The following table shows settings for an example DB instance. When the settings are as you want them, click Continue.

   For this parameter...	...Do this:
   License Model	Select the default, General-Public-License, to use the general license agreement for MySQL. MySQL has only one license model.
   DB Engine Version	Select the default version of MySQL. Note that Amazon RDS supports multiple versions of MySQL in some regions.
   DB Instance Class	Select db.m1.small to select a configuration that equates to 1.7 GB memory, 1 ECU (1 virtual core with 1 ECU), 64-bit platform, and moderate I/O capacity.
   Multi-AZ Deployment	Select No to create your DB instance in a single availability zone.
   Auto Minor Version Upgrade	Select Yes to enable your DB instance to receive minor DB engine version upgrades automatically when they become available.
   Allocated Storage	Type 5 to allocate 5 GB of storage for your database.
   Use Provisioned IOPS	Leave the check box unselected. This option turns on Provisioned IOPS (I/O operations per second), a high-performance storage option in Amazon RDS that is optimized for I/O-intensive, transactional (OLTP) database workloads.
   DB Instance Identifier	Type a name for the DB instance that is unique for your account in the region you selected. You may chose to add some intelligence to the name such as including the region and DB engine you selected, for example west2-mysql-instance1.
   Master User Name	Type a name using alphanumeric characters that you will use as the master user name to log on to your DB instance. This will be the user name you use to logon to your database on the DB instance for the first time.
   Master User Password	Type a password that contains from 8 to 16 printable ASCII characters (excluding /,", and @) for your master user password. This will be the password you will use when you use the user name to logon to your database.

   

7. On the Additional Configuration page, provide additional information that RDS needs to launch the MySQL DB instance. The table shows settings for an example DB instance. Specify your DB instance information, then click Continue.

   For this parameter...	...Do this:
   Database Name	Type a name for your database of up to 8 alpha-numeric characters. If you do not provide a name, Amazon RDS will not automatically create a database on the DB instance you are creating.
   Database Port	Leave the default value of 3306 unless you have a specific port you want to access the database through. MySQL installations default to port 3306. Important You cannot change the port once you create the DB instance, so it is very important that you determine the correct port to use to access the DB instance.
   Choose a VPC	This setting depends on the platform you are on. If you are creating a DB instance on the EC2-VPC platform, select the default VPC. If you are creating a DB instance on the E2-Classic platform, select Not in VPC. For more information about VPC, see Amazon RDS and the Amazon Virtual Private Cloud Service.
   Publicly Accessible	(Only applies if you choose a VPC) Select Yes to give the DB instance a public IP address; otherwise, select No. For more information about hiding DB instances from public access, see Hiding a DB instance in a VPC from the Internet.
   Availability Zone	Leave the default of No Preference unless you want to specify a particular Availability Zone.
   Option Group	Select the default value of default:mysql-5-5 since this option group is used with the MySQL version you selected on the previous page.
   Parameter Group	Leave the default value of default.mysql5.5 unless you created your own DB parameter group. For more information about parameter groups, see Working with DB Parameter Groups.
   DB Security Groups	Select the DB security group that you created in a previous step in the Getting Started section.

   

8. On the Management Options page, you can specify backup and maintenance options for your DB instance. Accept the default values, and then click Continue.

   

9. On the Review page, review the options for your DB instance. If you need to make any changes, click Back to return to the appropriate page, and then make the necessary corrections. When all the settings are as you want them, click Launch DB Instance.

10. On the final page of the wizard, click Close.

11. On the RDS console, the new DB instance appears in the list of DB instances. The DB instance will have a status of creating until the DB instance is created and ready for use. When the state changes to available, you can connect to a database on the DB instance. Depending on the DB instance class and store allocated, it could take several minutes for the new DB instance to become available.