Live tests for MySQL

[Archmonger]

Current Situation

MySQL tests are currently mocked. Currently only our Postgres and Sqlite database backends use live tests.

Proposed Actions

1. Create live tests within the scripts/ folder, based on the current postgres and sqlite tests.
2. Add these new tests to the Hatch CI
3. Install MySQL onto the local testing environment
4. Run the live tests
5. Bugfix MySQL connectors, if needed
6. Update the CI to leverage these new tests.
7. Update MySQL test configuration to match the CI settings, if needed.