The Xojo MySQL plugin only supports very basic encryption which means you have to downgrade the MySQL server connection security.
Unfortunately, as of MySQL 8.0.28, MySQL no longer supports the TLSv1 and TLSv1.1 protocols. This means that Xojo can no longer connect unless you disable TLS altogether (which may not be possible in some environment).