Congratulations to our 2022 Qt Champions!

Connecting to MySQL Server using SSL (AWS RDS)

  • Hey all,
    First time posting!

    Having a bit of trouble using an SSL connection to a MySQL server. AFAIK I have all the prerequisites installed such as, MySQL Connector and OpenSSL. Since I'm using AWS and they only provide a CA file, I have used the code below;

    Db = QSqlDatabase::addDatabase("QMYSQL");
    Connected =;

    There's plenty of information out there on opening an SSL connection, there's even a nice example in the documentation of QSqlDatabase. The issue I'm having is that I can't find much information regarding the error I'm getting.

    QMYSQLDriver::open: Illegal connect option value 'SSL_CA=rds.pem'

    I know I'm doing something wrong, just can't figure out what. Do I need to rebuild the MySQL libraries with SSL support or does the Qt binaries already come with that enabled?

    I'm on Windows 10 using QT 5.5.

    My apologies if I've missed something obvious.

  • Lifetime Qt Champion

    Hi and welcome to devnet,

    The support for that option as been added to Qt 5.6. You should update to either 5.6.1 (just released) or you can also consider 5.7RC.

Log in to reply