Change max_connect_errors in MySQL

Question

I need to change max_connect_errors on MySQL but I have no SSH control into the server, can you change it just using a mysql query?

If not can anyone advise how I would change this on amazon's RDS service? It doesn't seem to be in their parameter options.

Thank you!

Answer 1

Here's how I fixed it:

1. Create a new db parameter group (using command line tools, or console)
2. Change max_connect_errors in the new parameter group. My command looked like this rds-modify-db-parameter-group -C cert-xxxxxx.pem -K pk-xxxxx.pem --db-parameter-group-name=customdb --parameters "name=max_connect_errors,value=10000,method=immediate" or it can be done in the console.
3. Modify your database in console to use new parameter group
4. Restart rds instance. When it comes back it will use the new parameter group with the higher max_connect_errors

Answer 2

It seems Amazon now allows changing this parameter.

You might also want to set skip_name_resolve to 1, unless you need it.

Answer 3

First you need to create an RDS parameter group. This is a "profile" of settings that you can apply to your RDS instance.

Next, you need to use the RDS command line client, or API tools to make the settings modifications to your RDS parameter group.

You also need to make sure the RDS parameter group is applied to your RDS instances

Dave