Error Connecting mysql ERROR 2026 (HY000): TLS/SSL error: self-signed certificate in certificate chain

After a recent update in mysql client starting MariaDB 15.2 and MySQL clients SSL is enabled by default (ssl-verify-server-cert=TRUE).

Now when you connect using the following command which was being used since ages 

mysql -h <host> -u <user> -p

the following error is seen

ERROR 2026 (HY000): TLS/SSL error: self-signed certificate in certificate chain
 

Now to connect you have the following options

1. Connect using SSL
2. use the command
   • mysql -h <host> --skip-ssl-verify-server-cert -u <user> -p
3. Modify Config

   • Create a file /etc/mysql/conf.d/no-ssl-verify.cnf with the following content

     [client] 
     ssl-verify-server-cert=FALSE

Using any of the options above you will be able to connect to mysql as usual

Happy SQL