Cannot load data from database executing query "SELECT * FROM Environment". Please check query or connection string.

Hi,
I am trying to set up Data Server. I am using the following flexmonster-config.json:

{
  "DataSources": [
    {
      "Type": "database",
      "DatabaseType": "mysql",
      "ConnectionString": "Server=[REDACTED];Port=3306;User=[REDACTED];Password=[REDACTED]";Database=[REDACTED]",
      "Indexes": {
        "environment": {
          "Query": "SELECT * FROM Environment"
        }
      }
    }
  ],
  "Security": {
    "Authorization": {
      "Enabled": false
    },
    "CORS": {
      "AllowOrigin": "*"
    }
  },
  "DataStorageOptions": {
    "DataRefreshTime": "60"
  },
  "Port": "9500"
}

I am receiving the following error:

2022-07-06 18:02:54.5551|ERROR|Flexmonster.DataServer.Core.IPrepopulatingService|Index environment cannot be loaded. Details: Cannot load data from database executing query "SELECT * FROM Environment". Please check query or connection string. 
at Flexmonster.DataServer.Core.DataLoaders.DataLoader.Load(String index)
at Flexmonster.DataServer.Core.DataStorages.DataStorage.GetOrAddAsync(String cacheKey)
at Flexmonster.DataServer.FlexmonsterPrepopulatingCacheService.TryLoadIndex(IServiceScope scope, String indexName)

I verified that the server can connect to MySQL and that the IP and credentials are correct by using the MySQL command line tool on the server.
I searched the knowledgebase and tried ignorePrepared, the timeout suggestion, and tried using backticks. It did not work in any of those cases.
The only thing I can think of is that the password has an " in it that I had to escape in the JSON (\" in JSON). I will work with my ops team to change that and update here, but is there anything else I can try?