Plugin caching_sha2_password could not be loaded

The following code yields an error: mariadb.OperationalError: Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is 'c:/Program Files/MariaDB/MariaDB Connector C 64-bit/lib/plugin/caching_sha2_password.dll'

The issue seems to be that the MariaDB server installs itself in 'C:\Program Files\MariaDB 10.5' and the DLL seems to be located here instead: 'C:\Program Files\MariaDB 10.5\lib\plugin'

import mariadb

mydb = mariadb.connect(

        host="localhost",

        user="root",

        password="password",

        database="master"

    )