Connect to secure MySQL

1

Hi

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

2

Did you get this working?

Here is a good guide for MySQL with TLS: https://www.digitalocean.com/community/tutorials/how-to-configure-ssl-tls-for-mysql-on-ubuntu-16-04