1 Answer
- Newest
- Most votes
- Most comments
1
Hello.
Lightsail database parameters can be changed using the AWS CLI.
https://docs.aws.amazon.com/lightsail/latest/userguide/amazon-lightsail-updating-database-parameters.html
If you are using MySQL, you can change it using the AWS CLI below.
You must restart the Lightsail database after making changes.
aws lightsail update-relational-database-parameters --relational-database-name "db-name" --parameters "parameterName=time_zone,parameterValue=Asia/Tokyo,applyMethod=immediate"
AWS CLI can be executed from CloudShell.
https://docs.aws.amazon.com/cloudshell/latest/userguide/welcome.html
Relevant content
- asked 2 years ago
- asked 3 years ago
- AWS OFFICIALUpdated a year ago
Could not found London time zone. how can I set time zone for Europe/London
Lightsail databases can use almost the same parameters as RDS. Therefore, you can only use the time zones listed in the document below. Unfortunately "Europe/London" is not available in the Lightsail database. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Concepts.LocalTimeZone.html
If you are in Europe, you should be able to use the following time zones.