Africa/Lagos time zone not available when changing time zone for rds mysql

You can set "time_zone" parameter to Africa/Casablanca" (also UTC +1in the custom parameter group attached to the RDS instance, since Africa/Lagos is not available in the list.

Alternative Recommendation

1. Set in session - Use time_zone [2] You can set your parameter to UTC and use SET time_zone = '+01:00'; command to set your time zone in a session connection. Please note that set the time zone in the session only affects the current connection, not the overall database configuration, so the time zone setting is only valid for the current session.

2. (Better) You can have the database be Time zone-agnostic (all data in DB is UTC), and have the application be Time zone-aware.

A time zone-agnostic database stores all datetime data in UTC, while a time zone-aware application handles the conversion between UTC and local time zones( UTC +01 in your case), providing consistency in data storage and flexibility in time management.