DB: client does not support authentication protocol

[ben]

Wappler Version: 5.3.1
Operating System: Windows 11
Server Model: NodeJS
Databse: MySQL

Expected behavior

Be able to connect to a remote database

Actual behavior

I get the following error message

How to reproduce

Create a database in Railway.app and connect using the recommended settings as in

In Wappler, this looks like

Railway.app Solution:

mysql2

Edited

PostgreSQL works like a charm

[George]

Ben, select the MySQL8 as database type and not MySQL/MariaDB, which essentially uses mysql2 in NodeJS

[ben]