MySQL v8.x defaults to 'caching_sha2_password'

[mdebarros]

MySQL v8.x defaults to 'caching_sha2_password'. The current version of mysql driver for NodeJS does not support this authentication plugin.

Here is the MySQL issue to address support 'caching_sha2_password':
mysqljs/mysql#1959

Currently we have to manually change the authentication plugin to 'mysql_native_password' using the following command:

ALTER USER 'central_ledger'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

[mdebarros]

This issue is blocked by the following PRs:

• Latest PR to fix this issue: Fix MySQL 8.0.x incompatibilities mysqljs/mysql#1962
• Original PR to fix this issue: Support MySQL 8 Authentication mysqljs/mysql#2233