AWS RDS – Aurora Grant Corruption

When making changes to users or grants and the changes don’t appear to take effect, be sure to check any warnings that result from these changes.

mysql> flush privileges;
Query OK, 0 rows affected, 4 warnings (0.24 sec)

mysql> show warnings;
+---------+------+-------------------------------------+
| Level   | Code | Message                             |
+---------+------+-------------------------------------+
| Warning | 1292 | Truncated incorrect time value: 'N' |
| Warning | 1292 | Truncated incorrect time value: 'Y' |
| Warning | 1292 | Truncated incorrect time value: 'N' |
| Warning | 1292 | Truncated incorrect time value: 'Y' |
+---------+------+-------------------------------------+
4 rows in set (0.16 sec)

After encountering this issue, I had to rebuild on another server as the RDS controlled mysql database does not allow a full rebuild from an end user perspective.