MySQL RDS 'max_connections_per_hour' error, what are my options. This is not the 'max_connections' parameters, but per hour.

Question

I'm getting the following error for a DB I have. (db.t2.micro)

```
“1226 (42000): User ‘?????????’ has exceeded the ‘max_connections_per_hour’ resource (current value: 85)”
```

Note that this is not the typical 'max_connections' parameter.

I do not see the parameter under my.sql.user (as if it doesn't exist), but I am getting the error nonetheless.

Most of the solutions that I read about include upgrading the instance, which I am willing to do but for my current application it would be overkill. Most of my open and close connections are simple api request.

85 connections in an hour doesn't seem like much, there has to be another solution.

Answer

`MAX_CONNECTIONS_PER_HOUR` is a MySQL per-user parameter.  To remove this, you can use:
```sql
ALTER USER user@host MAX_CONNECTIONS_PER_HOUR 0;
```

MySQL RDS 'max_connections_per_hour' error, what are my options. This is not the 'max_connections' parameters, but per hour.

相關內容