Can't connect mysql8.4 because mysql8.4 no longer supports the mysql_native_password plugin

**Node version**: v20.14.0
**Sails version** _(sails)_: 1.5.11
**ORM hook version** _(sails-hook-orm)_: 4.0.3
**Sockets hook version** _(sails-hook-sockets)_: 3.0.0
**Organics hook version** _(sails-hook-organics)_: not use
**Grunt hook version** _(sails-hook-grunt)_: not use
**Uploads hook version** _(sails-hook-uploads)_: not use
**DB adapter & version** _(e.g. sails-mysql@5.55.5)_: sails-mysql@3.0.1
**Skipper adapter & version** _(e.g. skipper-s3@5.55.5)_: not use

sails-mysql not support caching_sha2_password , please support it to use mysql2😣

The issue names sails-mysql@3.0.1, mysql2, and MySQL 8.4 but provides no file or test entry point. Start by reproducing the connection with Node v20.14.0, Sails 1.5.11, and MySQL 8.4, then inspect the adapter's authentication support. Done means a MySQL 8.4 connection works without requiring mysql_native_password.

Written by the indexing model from the issue text.