Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Tutorial: Creating a MySQL DB cluster with a custom parameter group - Amazon Aurora

Tutorial: Creating a MySQL DB cluster with a custom parameter group

In this tutorial, you create a MySQL DB cluster with a custom parameter group. For more information about parameter groups, see DB cluster parameter groups for Amazon Aurora DB clusters.

Important

There's no charge for creating an AWS account. However, by completing this tutorial, you might incur costs for the AWS resources you use. You can delete these resources after you complete the tutorial if they are no longer needed.

To create a DB cluster with custom configurations and settings, you can use custom parameter groups. Custom parameter groups are particularly helpful if you work with multiple databases and want to uniformly configure settings for them.

By completing these steps, you learn:

  • How to use Amazon Aurora to create a MySQL DB cluster with a custom parameter group.

  • How to use specific parameters for MySQL DB clusters.

To complete this tutorial, perform the following tasks:

  1. Create a DB cluster parameter group with the MySQL parameter default_password_lifetime.

  2. Create a MySQL DB cluster with the custom DB cluster parameter group that you created.

Prerequisites

This tutorial requires you to have an AWS account and a user with administrative access. If you don't already have those set up, complete the steps in the following sections:

Create an Amazon Aurora DB cluster parameter group

In this tutorial, you learn how to create a custom parameter group with default_password_lifetime for a MySQL DB cluster in the console. The default_password_lifetime parameter controls the number of days before the client password automatically expires. For more information on other parameters available for MySQL DB clusters, see Aurora MySQL configuration parameters .

To create a parameter group
  1. Open the Amazon RDS console and choose Parameter groups.

  2. For Custom parameter groups, choose Create parameter group.

  3. Set the parameter group details.

    1. Enter a name for the parameter group.

    2. Enter a description of the parameter group.

    3. For Engine type, choose Aurora MySQL.

    4. For Parameter group family, choose aurora-mysql8.0.

    5. For Type, choose DB cluster parameter group.

  4. Choose Create.

The new DB cluster parameter group appears on the Parameter groups page in the Amazon RDS console. The following steps illustrate how to modify parameter values to customize your parameter group.

Modify parameter value in your custom parameter group

Use the following steps to modify the parameter value in the parameter group that you created in Create an Amazon Aurora DB cluster parameter group.

To modify parameter values in your parameter group
  1. Open the Amazon RDS console and choose Parameter groups.

  2. For Custom parameter groups, choose the name of the DB cluster parameter group you created.

  3. Choose Edit.

  4. In the Filter parameters search box, search for the custom parameter default_password_lifetime.

  5. Select the check box next to the parameter and enter a value the number of days to set for this password lifetime parameter.

  6. Select Save Changes.

The custom parameter group is now available to associate with Amazon Aurora for MySQL 8.0 DB cluster.

Create MySQL DB cluster with a DB cluster parameter group

Finally, create a MySQL DB cluster with the custom parameter group that you made in the previous steps. The following steps show how to create the MySQL DB cluster with your custom parameter group.

To create a DB cluster with a custom parameter and new option group
  1. Open the Amazon RDS console and choose Databases.

  2. Choose Create database.

  3. For Choose a database creation method, choose Standard Create.

  4. For Engine options, choose Aurora (MySQL Compatible).

  5. Select Additional Configuration.

    • For Initial database name, choose a name for your DB cluster.

    • Under the DB cluster parameter group dropdown, select the name of the DB cluster parameter group you created previously.

  6. For this tutorial, you can leave the default settings for any other DB settings or modify them as required.

  7. Choose Create database.

RDS creates a new MySQL DB cluster with a custom parameter group group. To see more information on this database, see the Databases page of the Amazon RDS console.

In this tutorial, you configured a MySQL DB cluster with tailored settings using a custom parameter group. This newly created MySQL DB cluster manages the user password lifetime by using the parameter default_password_lifetime. To optimize your database, you can apply additional setting in your custom parameter group and add options.

After you have finished creating your customized DB cluster, you should delete your resources to avoid incurring unwanted costs. To delete a DB cluster, follow the instructions in Deleting Aurora DB clusters and DB instances.

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.