Problem Installer Database Connection:
When trying to validate a database connection an error with the message “Error reading database variables” is returned.
Option 1 When running on certain MySQL instances that have “ANSI_QUOTES” enabled by default in their sql mode. MySQL interprets anything in double-quotes as identifiers rather than strings, which most likely causes the issue.
- This seems to be a known setting for Digital Ocean found here:
SQL requests with double-quotes not working with managed database
- To overcome the issue, please remove the ANSI_QUOTES SQL mode, by following the instructions in the link:
How to Set Global SQL Mode on MySQL Clusters
How to resolve various Database Issues?