Change max_connect_errors in MySQL

Asked 2010-12-13T13:16:40.570

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!

mysql amazon-rds

Edit Report

1 Answer

-3

show variables like 'max_connect_errors';
/* to show current setting */

set global max_connect_errors=100000000;
/* or any number you want */

make sure you login as an user have privileges to execute set global

This is no good for amazon-rds

answered 2010-12-13T14:00:15.367