Wednesday, November 3, 2021

SSL Connection Error: SSL is required but the server doesn’t support it.

When users using connecting MYSQL using MySQL Workbench they received following error

By default MySQL Workbench, use SSL and users may receive above error. It is recommended to use certificates to avoid above error. In case, if you do not have the certificates then you can follow below steps to skip the certificate and connect to the MySQL Database
 



Option 1:
  • Open MySQL workbench
  • Right click on MySQL instance and select "Edit Connection"
  • Go to the "SSL" tab under Connection Method
  • Choose "If Available" instead of "Required" in the drop-down for the "Use SSL"
  • Click the "Test Connection" and you should connect without errors.

Option 2:

  • Right click on MySQL instance and select "Edit Connection"
  • Go to “Advanced” tab and enter "useSSL=0" in the 'Others' tab
  • Click the "Test Connection" and you should connect without errors
Option 3:

 MySQL Workbench version 8.0.26 and below doesn’t use SSL Options by default

Thanks & Regards
http://oracleracexpert.com, Oracle ACE

11 comments:

  1. Fast-track your data analytics and machine learning
    career with guaranteed placement opportunities. Most extensive, industry-approved experiential learning program ideal for future Data Scientists.

    ReplyDelete
  2. Love to read it, waiting for More New Update and I Already Read your Recent Post it's Great. Thank you for sharing useful information. If you like to Know Azerbaijan Medical Journal Visit our website for More Medical Science Information.

    ReplyDelete
  3. Good on this blog commenting point. Thanks for writing such a good Article on this Topic. I am impressed with your way of the article with this depth. Enjoy this post, and I will try to read and review more.
    Packing And Moving
    Vehicle Transport
    International Relocation
    Employee Relocation

    ReplyDelete
  4. After reading your article I was amazed. I know that you explain it very well. business

    ReplyDelete
  5. I just thought it may be an idea to post incase anyone else was having problems researching but I am a little unsure if I am allowed to put names and addresses on here. 토토커뮤니티

    ReplyDelete
  6. Howdy. Very nice web site!! Guy .. Excellent .. Wonderful .. I’ll bookmark your web site and take the feeds additionally…I am satisfied to locate numerous helpful information here within the article. Thank you for sharing. 토토커뮤니티

    ReplyDelete
  7. Your texts on this subject are correct, see how I wrote this site is really very good. 먹튀검증사이트

    ReplyDelete
  8. betflix Deposit and withdraw as funds to play online slots or try to play Usually, โปรโมชั่น

    ReplyDelete
  9. Actually I read it yesterday but I had some thoughts about it and today I wanted to read it again because it is very well written. 먹튀검증사이트

    ReplyDelete
  10. Cool you inscribe, the info is really salubrious further fascinating, I'll give you a connect to my scene. 토토커뮤니티

    ReplyDelete
  11. During this website, you will see this shape, i highly recommend you learn this review. 토토커뮤니티

    ReplyDelete