external(LAN) mysql db for recorder - "Plugin caching_sha2_password could not be loaded"

Configuration
1

I have set up a database on a computer that provides the database on a lan-host. The server has been confirmed running with mysql(CLI) from within the same LAN as hassio.

Hassio logs:

## Log Details (ERROR)

Wed Sep 12 2018 11:38:53 GMT+0200 (Central European Summer Time)

Error during connection setup: (_mysql_exceptions.OperationalError) (2059, 'Plugin caching_sha2_password could not be loaded: Error loading shared library lib/mariadb/plugin/caching_sha2_password.so: No such file or directory') (Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)

Configuration:

recorder:
  db_url: mysql://hassio:[email protected]/hassio?charset=utf8
2

Apparently not compatible with mysql 8. Opted to downgrade mysql to 5.5, however, there is also possible to run mysqld with:

--default-authentication-plugin=mysql_native_password