Default authentication plugin (MySQL)

[constup]

Introduction and description

MySQL has different default authentication plugins for different versions of the server. The most common are mysql_native_password, sha256_password and caching_sha2_password. The first two of those are deprecated in some versions of the server.

Task

Implement configuration of default authentication plugin based on the selected version of the server. When the container is up, MySQL service must not report authentication plugin deprecation warnings.

The feature (of setting up a default non-deprecated authentication method) must be documented in the in-project documentation (implemented_configuration.adoc). A general notification is enough, with a note to look at the relevant configuration file to see which authentication methods is set up for the version of the server that user chose.

Relevant global variables

• projectinit_database_version: contains the version of the database engine

Relevant connected features

Docker healthcheck is implemented in the compose file. It may trigger deprecation warning if it's not set up correctly.

Acceptance criteria

• Follow the ProjectInit.sh contribution guidelines.
• MySQL service must not throw deprecation warnings when MySQL Docker service is up.
• In-project documentation is updated, as described in the Task.