Any update on this? Please let us know if any, as it will speed up our Maxscale testing.

Team,
Could you please provide your comments on this? Is there anything that we are missing?

Are you sure your password is correct?
Does select password('###your_password##') equal to '*5EDBD32E469DAE0CE10E6999C3899DEFCB9F12E0'

The password that we enter is "maxpwd" for maxuser
In the table it is listed as : SELECT User, Host, Password FROM mysql.user;
--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------

4 rows in set (0.00 sec)

Password seems to be correct:
select password('maxpwd');
-------------------------------------------

-------------------------------------------

-------------------------------------------
1 row in set (0.00 sec)

If you do not see the same behaviour on an x86 platform, then I would guess (a pure guess) that this is somehow related to the fact that Linux on s390x is big-endian while Linux on x86 is little-endian.

HI All,
I am confusing by the same issue.

My maxscale version is 2.5.5,
when I login with the correct password by DBeaver 7.2.2 (mysql jdbc 5.1.48 ), I got the same error: Access denied for user xxx

I checked log and found that the password is changing every time when I login.

And every thing is ok when use maxscale 2.4.1.

How I can fix this issue ?

[root@db_1111_middle_02-210-37 maxscale]# maxscale -V
MaxScale 2.5.5 - 91c3b76195d0057ddbe572bbb8d17f6ac6b09d5e
CMake flags: -DBUILD_TESTS=N -DBUILD_MMMON=Y -DBUILD_CDC=Y -DBUILD_GUI=Y -DPACKAGE=Y -DDISTRIB_SUFFIX=rhel.7

2020-10-27 16:45:15 info : (2) (find_user): Found matching user 'sysbench'@'10.0.0.108' for client 'sysbench'@'10.0.0.108' with sufficient privileges.
2020-10-27 16:45:15 warning: (2) [mariadbclient] (send_authetication_error): Authentication failed for user 'sysbench'@[10.0.0.108] to service 'EC-Read-Write-Service'. Originating listener: 'EC-Read-Write-Listener'. MariaDB error: 'Access denied for user 'sysbench'@'10.0.0.108' (using password: YES)'. Authenticator error: 'Client gave wrong password. Got hash D3F74539A8551F9E63802480A1CED6F100145437, expected B9049AE9D8054CF88C12F5DEAD8609EED695CF45'.
2020-10-27 16:45:15 info : (session_free): Stopped EC-Read-Write-Service client session [2]
2020-10-27 16:45:15 info : (update_users): Read 31 user@host entries from 'EC-server1' for service 'EC-Read-Write-Service'. The data was identical to existing user data.
2020-10-27 16:45:21 info : (3) (find_user): Found matching user 'sysbench'@'10.0.0.108' for client 'sysbench'@'10.0.0.108' with sufficient privileges.
2020-10-27 16:45:21 warning: (3) [mariadbclient] (send_authetication_error): Authentication failed for user 'sysbench'@[10.0.0.108] to service 'EC-Read-Write-Service'. Originating listener: 'EC-Read-Write-Listener'. MariaDB error: 'Access denied for user 'sysbench'@'10.0.0.108' (using password: YES)'. Authenticator error: 'Client gave wrong password. Got hash 477016F41A29F2EB2597BEABD5C9CB0278ACCA4B, expected B9049AE9D8054CF88C12F5DEAD8609EED695CF45'.

Same issue here, CentOS 8.

Tried both with MariaDB 10.3 and 10.5 and Maxscale 2.4 and 2.5. with docker volumes to make maxuser permanent.

MariaDB [(none)]> SELECT user, host, password FROM mysql.user ORDER BY 1;
-----------------------------------------------------------

-----------------------------------------------------------

-----------------------------------------------------------
3 rows in set (0.009 sec)

master_1 | 2021-06-21 12:08:15 22 [Warning] Access denied for user 'maxuser'@'192.168.0.5' (using password: YES)

Same for slaves, of course. This is really unpleasant. What happens here?

~# id=$(docker ps -a | grep "_maxscale" | grep -v "xited" | awk '

') && docker exec -it $id maxscale -V
MaxScale 2.4.17 - a8bfbbe254095d931aed351871fee72ce9ea645c
CMake flags: -DBUILD_TESTS=N -DBUILD_MMMON=Y -DBUILD_CDC=Y -DBUILD_GUI=Y -DPACKAGE=Y -DDISTRIB_SUFFIX=rhel.8

Sorry forgot to list the rights, given by a tutorial:

GRANT SELECT ON mysql.user TO 'maxuser'@'%';
GRANT SELECT ON mysql.db TO 'maxuser'@'%';
GRANT SELECT ON mysql.tables_priv TO 'maxuser'@'%';
GRANT SELECT ON mysql.roles_mapping TO 'maxuser'@'%';
GRANT SHOW DATABASES ON . TO 'maxuser'@'%';

Another fact: I use docker. Here is my compose file

version: '2'
services:
master:
image: mariadb
environment:
MYSQL_ALLOW_EMPTY_PASSWORD: 'Y'
volumes:

• ./sql/master:/docker-entrypoint-initdb.d
• maxmaster:/var/lib/mysql
  command: mysqld --log-bin=mariadb-bin --binlog-format=ROW --server-id=3000 --log-slave-updates
  ports:
• "4001:3306"

slave1:
image: mariadb
depends_on:

• master
  environment:
  MYSQL_ALLOW_EMPTY_PASSWORD: 'Y'
  volumes:
• ./sql/slave:/docker-entrypoint-initdb.d
• maxslave1:/var/lib/mysql
  command: mysqld --log-bin=mariadb-bin --binlog-format=ROW --server-id=3001 --log-slave-updates
  ports:
• "4002:3306"

slave2:
image: mariadb
depends_on:

• master
  environment:
  MYSQL_ALLOW_EMPTY_PASSWORD: 'Y'
  volumes:
• ./sql/slave:/docker-entrypoint-initdb.d
• maxslave2:/var/lib/mysql
  command: mysqld --log-bin=mariadb-bin --binlog-format=ROW --server-id=3002 --log-slave-updates
  ports:
• "4003:3306"

maxscale:
image: mariadb/maxscale
depends_on:

• master
• slave1
• slave2
  volumes:
• ./maxscale.cnf.d:/etc/maxscale.cnf.d
  ports:
• "4006:4006" # readwrite port
• "4008:4008" # readonly port
• "8989:8989" # REST API port

volumes:
maxmaster:
maxslave1:
maxslave2: