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 or 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 when you try to edit or add a new entry on a MySQL database the problem is because your Advanced Setting had been modified.
The resolution is to Edit your database, Select the Advanced tab and go to Advanced Settings.
CacherServerProperties Default Value
Erase the Value of the CacheServerProperties field.