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

9 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. 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
  3. After reading your article I was amazed. I know that you explain it very well. business

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

    ReplyDelete
  5. 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
  6. Cool you inscribe, the info is really salubrious further fascinating, I'll give you a connect to my scene. 토토커뮤니티

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

    ReplyDelete
  8. This is very interesting, but it is necessary to click on this link: voyance-tel-avenir.com

    ReplyDelete
  9. The Meghalaya Board's main office is located in Tura, West Garo Hills. The major responsibilities of the Meghalaya board are to administer board exams and to recognise state schools. The Meghalaya Board of School Education (MBOSE) will be announced. Details regarding the Meghalaya board's Guess Question Paper 2023 hslc and hsslc are two different types of hslc. Meghalaya 12th Model Paper 2023 Mbose Important Question Paper 2023, Guess Question Paper 2023 The MBOSE Board is in charge of all academic activities such as syllabi for all classes, curriculum upgrades, and so on. MBOSE is committed to providing high-quality education for all students' holistic development, with the goal of achieving excellence in their living standards.

    ReplyDelete