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

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

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

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

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

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

    ReplyDelete
  8. 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
  9. Great article! Your detailed explanation on resolving SSL connection errors is incredibly helpful. Addressing such issues is crucial for smooth data transmission. Speaking of data, considering the growing importance of data science in optimizing database performance, a comprehensive Data Science Course can enhance one's ability to analyze and interpret crucial data patterns. Courses like these contribute significantly to resolving intricate technical challenges in the ever-evolving tech landscape. Keep up the excellent work!

    ReplyDelete

  10. Oh no, it's always frustrating to encounter SSL connection errors! 😓 It seems like the server requires SSL but doesn't support it. Have you tried reaching out to the website administrator or technical support for assistance?

    On a different note, your mention of a "sad whatsapp dp" caught my attention. Sometimes, technology hiccups and glitches can be as disheartening as finding a sad display picture on WhatsApp. Let's hope both the SSL issue and any emotional downturns get resolved soon! 🤞🏼 #TechStruggles #SSLWoes #KeepSmilingOnWhatsApp

    ReplyDelete