How do I initialize character set settings for a new RDS MySQL instance

Question

I would like to set the following variable for my Amazon RDS server, where do I provide this setting when I create a new RDS instance?

character_set_server=utf8mb4

Note: I want these settings to be permanent and I don't want to modify them every time I re-start the server.

score 3 · Answer 1 · answered Jan 30 '12 at 23:37

3

You need to use an RDS DB Parameter Group to do that.

You can create new parameter groups through the aws dashboard but you won't be able to actually change any of the parameters. You'll need to use an API client for that.

As a warning, I don't think RDS yet supports using utf8mb4 in a parameter group. I get an error from the API when I attempt to set character_set_server to that value.

answered Jan 30 '12 at 23:37

ryansch

79
1
10

2

Just in case... You can now modify the collation and character-set parameters through DB Parameters Groups using the API, the CLI and the AWS Management Console. – rodrigobartels Jul 18 '14 at 14:56

How do I initialize character set settings for a new RDS MySQL instance

1 Answers1