SSL connection error: unknown error number QMYSQL: Unable to connect

[SGaist]

Hi and welcome to devnet,

What kind of certificate are you using for that database ?
Which version of Qt are you using ?
On which OS ?
Which version of MySQL ?

[Aditya20]

@SGaist I do not have any certificate added as of now.
QT version: 6.5.6
OS: Windows
MySQL version: 8.0.36

[Aditya20]

@Aditya20 said in SSL connection error: unknown error number QMYSQL: Unable to connect:

6.5.6

6.5.3

[Christian Ehrlicher]

Disable ssl on your mysql server and/or try to disable them with the appropriate connect options (but might not work when the mysql server is configured to not allow unencrypted connections).

[Aditya20]

@Christian-Ehrlicher I have already disabled SSL on MySQL server

[Aditya20]

I am still facing same issue. Any help would be appreciated

[JonB]

@Aditya20
I don't know what it will tell us, but to start out can you connect successfully using, say, MySQL Workbench and mysqldump?

[Christian Ehrlicher]

@Aditya20 said in SSL connection error: unknown error number QMYSQL: Unable to connect:

I am still facing same issue. Any help would be appreciated

And you still did not played around with the corresponding connect options ... so no help from my side possible.

[Aditya20]

@SGaist Any updates from your end for the issue

[SGaist]

@Aditya20 did you do the checks suggested by @JonB ?
Are you sure about the port ?
Are you sure that connections to that port are allowed ?

[Aditya20]

@SGaist I was finally able to resolve the issue by using skip_ssl in my.ini file.