Wappler 7.9.7 Database Manager rejects valid MySQL credentials on remote Docker target

1

Environment

  • Operating system: Windows 11

  • Wappler version: 7.9.7

  • Target: Remote Docker Production target

  • Server model: NodeJS

  • Database engine: MySQL 8.4

  • Database: retirementhome__prod

  • Database user: db_user

Problem

Wappler Database Manager cannot connect to the production MySQL database.

It displays:

Access denied for user 'db_user'@[REDACTED] (using password: YES)

The deployed Wappler NodeJS application connects to this database successfully as db_user. The production website and Server Connect actions work normally.

Database account verification

The MySQL account has been checked directly on the server:

  • db_user@% exists

  • The account is unlocked

  • Authentication plugin is caching_sha2_password

  • The account does not require SSL

  • It has the required privileges on retirementhome__prod

  • The database and all required tables exist

  • The deployed application successfully connects from its Docker container

The Wappler connection reaches MySQL because it receives error 1045 rather than timing out or being refused.

Troubleshooting already performed

  • Confirmed that the correct client IP is allowed in the target

  • Confirmed that the configured port maps to the production MySQL container

  • Confirmed the database name and username

  • Reset the MySQL password and entered the corresponding password into Wappler

  • Used a hexadecimal-only password to rule out escaping or unsupported-character problems

  • Restarted Wappler

  • Reopened and refreshed the database connection

  • Restarted the production application container

  • Confirmed that the deployed application still connects successfully

  • Confirmed that the problem remains isolated to Wappler Database Manager

Wappler also crashed once while saving the production database password. After restarting Wappler, the password appeared to be saved, but Database Manager continued returning error 1045.

Steps to reproduce

  1. Open the project in Wappler 7.9.7.

  2. Select the Production target.

  3. Open the db connection in Database Manager.

  4. Allow Wappler to fetch the database schema.

  5. Wappler returns MySQL error 1045.

Expected result

Wappler Database Manager should connect to retirementhome__prod using the configured db_user credentials and display its tables.

Actual result

Database Manager returns MySQL error 1045, despite the deployed Wappler application successfully using the production database.