[BUG] mysql scale cluster bench error: DDL command denied to user 'root'

[JashBook]

Describe the bug

kbcli version
Kubernetes: v1.26.3
KubeBlocks: 0.9.0-alpha.5
kbcli: 0.9.0-alpha.1

To Reproduce Steps to reproduce the behavior:

1. create mysql scale cluster

kbcli cluster create  mysql scale-joqsje                 --mode='raftGroup'                 --cpu=0.5                 --memory=1                 --storage=20                 --availability-policy=none --termination-policy=WipeOut  --version=ac-mysql-8.0.30-1  --replicas=3                     --proxy-enabled=true  --namespace default

2. do sysbench

kbcli bench  sysbench benchtest-scale-joqsje --cluster scale-joqsje --host scale-joqsje-vtgate.default.svc --user root --password "7bwd64fh" --database benchtest  --namespace default --port 15306 --threads 4                     --type oltp_read_write --tables 4 --size 1000 --duration 10 --driver mysql                      --extra-args="--auto_inc=false"

3. See error

kubectl get pod
NAME                                            READY   STATUS      RESTARTS       AGE
benchtest-scale-joqsje-cleanup-96cc7            0/1     Completed   0              7m35s
benchtest-scale-joqsje-precheck-hx27v           0/1     Completed   0              7m39s
benchtest-scale-joqsje-prepare-gvdll            0/1     Completed   0              7m28s
benchtest-scale-joqsje-run-0-qcd55              2/2     Running     0              7m22s

logs bench pod

➜  ~ kubectl logs benchtest-scale-joqsje-run-0-qcd55 kubebench
run sysbench
check mysql database exists
mysql host scale-joqsje-vtgate.default.svc connect success!
database benchtest exists
/usr/bin/sysbench
cd ./sysbench/src/lua;sysbench --db-driver=mysql --mysql-host=scale-joqsje-vtgate.default.svc --mysql-port=15306 --mysql-user=root --mysql-password=7bwd64fh --mysql-db=benchtest --table_size=1000 --tables=4 --time=10 --threads=4 --events=0 --percentile=99 --auto_inc=false --report-interval=1 oltp_read_write run
sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3)

Running the test with following options:
Number of threads: 4
Report intermediate results every 1 second(s)
Initializing random number generator from current time


Initializing worker threads...

FATAL: mysql_stmt_prepare() failed
FATAL: MySQL error: 1045 "target: benchtest.0.replica: vttablet: rpc error: code = PermissionDenied desc = SelectImpossible command denied to user 'root' for table 'sbtest1' (ACL check error) (CallerID: root)"
FATAL: `thread_init' function failed: ./oltp_common.lua:305: SQL API error
FATAL: mysql_stmt_prepare() failed
FATAL: MySQL error: 1045 "target: benchtest.0.replica: vttablet: rpc error: code = PermissionDenied desc = SelectImpossible command denied to user 'root' for table 'sbtest1' (ACL check error) (CallerID: root)"
FATAL: `thread_init' function failed: ./oltp_common.lua:305: SQL API error
FATAL: mysql_stmt_prepare() failed
FATAL: MySQL error: 1045 "target: benchtest.0.replica: vttablet: rpc error: code = PermissionDenied desc = SelectImpossible command denied to user 'root' for table 'sbtest1' (ACL check error) (CallerID: root)"
FATAL: `thread_init' function failed: ./oltp_common.lua:305: SQL API error
FATAL: mysql_stmt_prepare() failed
FATAL: MySQL error: 1045 "target: benchtest.0.replica: vttablet: rpc error: code = PermissionDenied desc = SelectImpossible command denied to user 'root' for table 'sbtest1' (ACL check error) (CallerID: root)"
FATAL: `thread_init' function failed: ./oltp_common.lua:305: SQL API error
FATAL: Thread initialization failed!
[]

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Additional context Add any other context about the problem here.