1.Create SSL keys as described in Creating SSL Certs.
2.Create a client certificate.
2.1. openssl pkcs12 -export -in client-cert.pem -inkey client-key.pem -certfile cacert.pem -out client.pfx
3.Grant privileges to the user as described in Grant Syntax.
3.1. GRANT ALL PRIVILEGES ON test.* TO 'root'@'localhost' IDENTIFIED BY 'goodsecret' REQUIRE SSL;
4.Run certmgr.msc and import the client certificate in the user store.
5.In the Advanced settings of your MySQL data source set the following values:
5.1. Certificate Store Location: CurrentUser
5.2. SSL Mode: Required
When you have that type of error while attempting to edit or add a new entry on a MySQL database the problem is because your Advanced settings have been modified.
The resolution is to Edit your database, Select the Advanced tab and go to More Settings.
CacherServerProperties Default Value
Erase the Value of the CacheServerProperties field.