How to modify MySQL database configuration in AWS RDS

In this article, I’m going to explain how to modify MySql parameters while you are using AWS RDS (Relational Database Service) for the MySql Database.

I write this post after fixing an error of “MySql ‘max_allowed_packet’ bytes error during import database” but you can do anything with MySql database configuration parameters after reading this post. Let’s start step by step on how to fix this and many more things.

After reviewing this article I understand what I have to do and how.

Here are the following steps.

1. Go to RDS page and click on “Parameter groups” text located in the left navigation.

2. Now create a new group by clicking on “Create the parameter group” orange button.

3. Fill-up parameter group form “Parameter group family” should be MySql version of your RDS instance than “Group name” and “Description” whatever you want.

4. New “Parameter group” was created as “test” now edit it and increase “max-allowed-packet” by entering “10000000” (10 MB) value should be in Bytes after entering value don’t forgot to click on “Save changes” button and make sure value is between 1024 Bytes to 1073741824 Bytes (1073 MB)

5. Now you can see your changes by click on the “Preview changes” button.

6. Now we have to change the “Parameter group” in our RDS instance. SO, modify an instance and select “Parameter groups” which we created.

7. Now after modifying RDS instance, you should Reboot it to apply your changes.

Read on StackOverflow

Originally published at krupalpatel92.blogspot.com on February 9, 2019.