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

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😣