I am getting the following error when trying to run an external query in BigQuery to a GCP MySQL instance:

Invalid table-valued function EXTERNAL_QUERY Failed to connect to MySQL database. Error: MysqlErrorCode(2059): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at [1:15]

This is my query:

SELECT * FROM EXTERNAL_QUERY("myproject.us-east4.my-externalConnection", "SELECT * FROM INFORMATION_SCHEMA.TABLES;");

I have other external queries working on MySQL 8.0. I'm unable to figure out how to bypass this issue on my MySQL 8.4 instance.