[solved] Complete new MP installation with MySQL DB fails (1 Viewer)

[horned_reaper]

After a clean MP and MySQL uninstallation and deleting all MP and MySQL program and data folders the new MP 1.38 installation fails because the database connection test fails, see attached screenshot.
With Maria DB it works.

 

[ajs]

I add AllowPublicKeyRetrieval=True but i dont know how its work with MySQL and/or MariaDB

But:

To specify the server’s RSA public key, use the ServerRSAPublicKeyFile connection string setting, or set AllowPublicKeyRetrieval=True to allow the client to automatically request the public key from the server. Note that AllowPublicKeyRetrieval=True could allow a malicious proxy to perform a MITM attack to get the plaintext password, so it is False by default and must be explicitly enabled.

Test build:

Mediaportal / Test Build · MediaPortal/MediaPortal-1@e1421ca

Home Theater and Digital Video Recording solution for Windows. - Mediaportal / Test Build · MediaPortal/MediaPortal-1@e1421ca

github.com

 

[horned_reaper]

Works like a charm with both MySQL and Maria database.
Thank you very much!