Mysql addon failure while connecting remote host

I am facing an issue when I try to connect to the remote database using MySQL addon I am getting the below message but it’s working fine for the local database.

For everyone in the community who find it relevant:

After checking with a senior database professional in his organization, we realized that the issue was happening because the organization was not allowing any direct connection to their “mysql database”, only allowing database connection through ssh tunnel.
In order to use this addon, direct connection is needed - without ssh tunnel.