Hi Railway Team / Community,

I'm deploying the SeaTable Enterprise Docker application on an 8GB/8vCPU plan, connecting to a Railway managed MySQL 8+ database service.

The application's internal components require the mysql_native_password authentication method to connect successfully. However, the Railway MySQL 8+ service defaults to caching_sha2_password.

When I attempt to change the database user's authentication method (using the root user provided by the service) via standard SQL:

SQL

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '********';

I receive the following error from the Railway MySQL service:

Error Code: 1524. Plugin 'mysql_native_password' is not loaded

This error indicates the necessary plugin isn't enabled or available on the managed MySQL instance, which currently prevents the SeaTable application from connecting to the database.

(We have confirmed other configurations are working correctly, for example, the connection to the Railway Redis service using the appropriate DTABLE_REDIS_* environment variables).

My question is: Is there any possibility to enable the mysql_native_password plugin on the Railway MySQL 8+ service?

Alternatively, are there any other server-side configurations or workarounds available on Railway's MySQL 8+ offering for applications that have this specific legacy authentication requirement?

can other variables be applied?

Thanks for any information you can provide!