specify7 and mysql8 compatibility issues

[timo11]

No description provided.

[timo11]

1. [Solved] Unable to login.
   Error: (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: ...

https://stackoverflow.com/questions/50469587/django-db-utils-operationalerror-2059-authentication-plugin-caching-sha2-pas

"
Starting with version 8.04 MySQL uses caching_sha2_password as default authentication plugin where previously mysql_native_password has been used (which causes compatibility issues with older services that expect mysql_native_password authentication).

Possible solutions:

Downgrade the MySQL Server to a version below that change or change the authentication plugin (on a user basis)

eg when creating the user:

CREATE USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
"

Creating master user with mysql_native_password made logging in possible.

[timo11]

2. Error when choosing a value from a combobox: Unknown system variable 'tx_isolation'

Mysql8 has renamed tx_isolation to transaction_isolation.

[benanhalt]

I updated some dependencies for this in 9b0376f

The tx_isolation issue stills seems to be occurring. It appears to come from the SQLalchemy library.

[tlammer]

Since we aren't supporting mysql 8 in Specify six yet, this doesn't need to be tested for now. Except to watch out that it doesn't cause problems with older versions of mysql.