Connect to secure MySQL


I’m a newbe. So please forgive if I ask silly questions but I’m trying to connect to an existing remote secure MySQL database. I’m using the MySQL data source plugin. I’m getting the following error ‘Error 1045: Access denied for user’.
I’ve confirmed I’m using the correct connection details (server,port,user, password)
I’m fairly sure the issue is I need to install the MySQL server certificates. I’ve searched online but I haven’t found any advise on how to install.

Any help is appricated

Did you get this working?

Here is a good guide for MySQL with TLS: