[bug] create mysql user will cause a mass of warning messages in mysql errorlog

[zhl003]

Describe the problem

To Reproduce

1. create mysql user through user cr
2. warning message occur

kubectl get mysqluser
NAME          USERNAME      SUPERUSER   HOSTS   TLSTYPE   CLUSTER   NAMESPACE   AVAILABLE
normal-user   normal_user   false       ["%"]   NONE      sample    default     True
super-user    super_user    true        ["%"]   NONE      sample    default     True

 kubectl logs sample-mysql-0 -c mysql --tail 10 
2022-12-01T16:45:53.857428+08:00 284 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'super_user'@'%'

2022-12-01T16:47:53.157472+08:00 320 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'normal_user'@'%'

2022-12-01T16:47:53.959515+08:00 322 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'super_user'@'%'

2022-12-01T16:49:53.358425+08:00 358 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'normal_user'@'%'

2022-12-01T16:49:54.158525+08:00 360 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'super_user'@'%'

bash-4.4$ mysqlbinlog -vv mysql-bin.000002|grep -vE '#|\/\*'
BINLOG '
r3mIYw9kAAAAdwAAAHsAAAABAAQANS43LjM5LTQyLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAACveYhjEzgNAAgAEgAEBAQEEgAAXwAEGggAAAAICAgCAAAACgoKKioAEjQA
AcpxHEc=
CREATE USER IF NOT EXISTS 'super_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9' REQUIRE NONE
ALTER USER 'super_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9'
GRANT ALL PRIVILEGES ON *.* TO 'super_user'@'%' WITH GRANT OPTION
CREATE USER IF NOT EXISTS 'super_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9' REQUIRE NONE
ALTER USER 'super_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9'
GRANT ALL PRIVILEGES ON *.* TO 'super_user'@'%' WITH GRANT OPTION
CREATE USER IF NOT EXISTS 'normal_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9' REQUIRE NONE
ALTER USER 'normal_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9'
GRANT USAGE ON *.* TO 'normal_user'@'%'
CREATE USER IF NOT EXISTS 'normal_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9' REQUIRE NONE
ALTER USER 'normal_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9'
GRANT USAGE ON *.* TO 'normal_user'@'%'
CREATE USER IF NOT EXISTS 'super_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9' REQUIRE NONE
ALTER USER 'super_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9'
GRANT ALL PRIVILEGES ON *.* TO 'super_user'@'%' WITH GRANT OPTION
CREATE USER IF NOT EXISTS 'normal_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9' REQUIRE NONE
ALTER USER 'normal_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9'
GRANT USAGE ON *.* TO 'normal_user'@'%'
create database sbtest
CREATE USER IF NOT EXISTS 'super_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9' REQUIRE NONE
ALTER USER 'super_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9'
GRANT ALL PRIVILEGES ON *.* TO 'super_user'@'%' WITH GRANT OPTION
CREATE USER IF NOT EXISTS 'normal_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9' REQUIRE NONE
ALTER USER 'normal_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*843322D4F26B0187F2892DC90E6A79354B9696D9'

Expected behavior

Environment:

• RadonDB MySQL version:

[Littlehhao]

这个警告信息对mysql 运行有影响吗