The server must be configured to handle SSL connections. Your host provider must do this. They need to create a server and client pair of SSL certificates, signed by the same CA. They will configure MySQL with the CA and server certs, and then provide you with the client cert to use in your code.
There is nothing you can do from your end if the server is not properly configured.