ERROR 1698 (28000): Authenticate failed, user: "prog_admin", auth_plugin: "mysql_native_password"

[lddlww]

reproduce step

mysql>create user 'prog_admin'@'10.5.126.%' identified by 'hNyJicOjzH5JZwJw';

mysql>grant all on *.* to 'prog_admin'@'10.5.126.%';

[shell] mysql -h10.5.126.189 -P3307 -uprog_admin -phNyJicOjzH5JZwJw
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1698 (28000): Authenticate failed, user: "prog_admin", auth_plugin: "mysql_native_password"

databend version
v0.9.5-nightly-6772df6(rust-1.68.0-nightly-2023-01-17T16:27:18.567251878Z)

mysql client version
mysql Ver 8.0.31 for Linux on x86_64 (MySQL Community Server - GPL)

am i missing somehting else?

[lddlww]

oh databend-query log tells me:

2023-01-19T06:08:10.019166Z  INFO databend_query::servers::mysql::mysql_handler: src/query/service/src/servers/mysql/mysql_handler.rs:90: MySQL connection coming: Ok(10.5.126.189:17968)
2023-01-19T06:08:10.021769Z ERROR databend_query::servers::mysql::mysql_interactive_worker: src/query/service/src/servers/mysql/mysql_interactive_worker.rs:140: MySQL handler authenticate failed, user_name: prog_admin, client_address: 10.5.126.189:17968, failure_cause: Code: 2201, displayText = unknown user 'prog_admin'@'%'

what mean is databend-query only support % now?