MySQL: default_authentication_plugin is deprecated and will be removed in a future release.

[seidior]

Describe the Feature / Enhancement

MySQL will be deprecating the "default_authentication_plugin" option, so we will need to switch to the newer SHA2-based authentication mechanism. This isn't supported by the mysql Node.js driver for MySQL (see mysql#1959), so the current recommendation is to switch to the mysql2 driver, which is fully supported by Knex as a drop-in replacement.

Additional Details and Resources

I have already tested the switch on my machine and it has no measurable impact on functionality of our application.

Correct Project Selected

• This issue is linked to the appropriate project

Labels

• This issue has appropriate labels.