MYSQL: Cannot list tables in database when using libmysql version 8

CREATE DATABASE mysql_test_db;
USE mysql_test_db;

CREATE TABLE table1
(
    id integer AUTO_INCREMENT,
    col1 bool,
    col2 int,
    col3 text,
    PRIMARY KEY(id)
);

CREATE TABLE table2
(
    id integer AUTO_INCREMENT,
    col1 bool,
    col2 int,
    col3 text,
    PRIMARY KEY(id)
);

#include <QCoreApplication>
#include <QString>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlError>
#include <QTextStream>

int main(int argc, char *argv[])
{
    QTextStream cout(stdout);
    QCoreApplication app(argc, argv);
    
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("localhost");
    db.setDatabaseName("mysql_test_db");
    db.setUserName("root");
    db.setPassword("password");
   
    if (!db.open()) {
        cout << "Open database error. " << db.lastError().text() << endl;
        return 1;
    }

    QStringList tables = db.tables();
    cout << "Number of tables: " << tables.count() << endl;
    for (int i=0; i<tables.count(); ++i) {
        cout << (i+1) << "." << tables[i] << endl;
    }
    return 0;
}

Number of tables: 0

Number of tables: 2
1.table1
2.table2