I have a remote server in which threre is an application running using mysql server version 8.0.36-0ubuntu0.22.04.1. I configured the remote connection and binded the address to 0.0.0.0. When I connect remotely from mysql server version 10.4.28-MariaDB, it connected perfectly fine.

A governmental institution wants an access on a certain view on the remote server using there own connection application, the connection always fails.

One of my troubleshooting, I installed an older version of mysql server on my machine (5.7.44-log) and tried to connect, but the connection fails.

Does the compatability is the issue, and if so, how can I grant the access on the views to the governmental institution using my current database version.

Thanks