I’m encountering an issue where I have set up maxscale as a database proxy.

After installing and configuration, when I connect using the maxscale user , data masking rules are applied successfully ensuring sensitive data is masked.

However, other database users connect directly to the mariadb server without going through maxscale. Consequently, data accessed by these users is not masked.

Observation:
When quering via maxscale ( mysql -u maxscaleuser-P ) , I see masked data, but when querying via other user ( mysql -u other user-p) data not masked.

Desired outcome:
I need all database users to connect through maxscale to ensure consistent application of data masking rule.

Desired outcome:

I need all database users to connect through maxscale to ensure consistent application of data masking rule.