... | ... | @@ -146,13 +146,15 @@ Sorted by `Status,Environment`: |
|
|
| :white_check_mark: | Digital Ocean | Specifically tested w/[managed MySQL 8.0](https://www.digitalocean.com/products/managed-databases-mysql) |
|
|
|
| :white_check_mark: | Docker `mysql` | Specifically tested w/[8.0, 8.0-oracle, and 5.7](https://hub.docker.com/_/mysql) |
|
|
|
| :white_check_mark: | Google Cloud SQL | Specifically tested w/5.6. Warning from docs: ["not guaranteed to provide up-to-date time settings"](https://cloud.google.com/sql/docs/mysql/known-issues) |
|
|
|
| :white_check_mark: :question: | Amazon RDS | Not tested. There are old-google-cached forum posts which imply gradual evolution toward support. The current ["Local time zone" page](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.LocalTimeZone) seems to affirm, but it doesn't specifically mention session-scoped timezones. |
|
|
|
| :tools: | Azure Database | Use [`az_load_timezone()`](https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters#working-with-the-time-zone-parameter) |
|
|
|
| :tools: | CentOS MariaDB/MySQL | Use `mysql_tzinfo_to_sql` |
|
|
|
| :tools: | cPanel (with root access) | Use `mysql_tzinfo_to_sql` |
|
|
|
| :tools: | cPanel/WHM (with root access) | Use `mysql_tzinfo_to_sql` |
|
|
|
| :tools: | Debian/Ubuntu MariaDB/MySQL | Use `mysql_tzinfo_to_sql` |
|
|
|
| :tools: | Nix MariaDB/MySQL | Use `mysql_tzinfo_to_sql` |
|
|
|
| :octagonal_sign: :question: | cPanel (without root access) | Not tested. If you have MySQL admin rights, you might use `mysql_tzinfo_sql` locally and send to server. Still requires MySQL admin. |
|
|
|
| :question: | Amazon RDS | Needs testing/clarification. There are old google-cached forum posts which imply gradual evolution toward support. The current ["Local time zone" page](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.LocalTimeZone) seems to affirm, so probably :white_check_mark: ... but the docs don't specifically mention session-scoped timezones. |
|
|
|
| :question: | cPanel/WHM (without root access) | Needs testing/clarification. If you lack SSH-root but have MySQL-root (or similar), you could use `mysql_tzinfo_sql` locally and send to the server (via phpmyadmin or `mysql -h`). Key question is whether you have MySQL admin rights. |
|
|
|
| :question: | Pantheon | Needs testing/clarification. |
|
|
|
| :question: | WP Engine | Needs testing/clarification. |
|
|
|
|
|
|
## Related Tasks
|
|
|
|
... | ... | |