Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Closed
zhl003 opened this issue Dec 1, 2022 · 1 comment · Fixed by #749
Closed

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

zhl003 opened this issue Dec 1, 2022 · 1 comment · Fixed by #749
Assignees
@acekingke @zhl003
Labels
bug Something isn't working
Milestone
v3.0.0

Comments

@zhl003
Copy link
Collaborator

zhl003 commented Dec 1, 2022 •
edited
Loading

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:
@zhl003 zhl003 added the bug Something isn't working label Dec 1, 2022
@zhl003 zhl003 added this to the v3.0.0 milestone Dec 1, 2022
@zhl003 zhl003 mentioned this issue Dec 7, 2022
Merged
@Littlehhao
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@acekingke acekingke

@zhl003 zhl003

Labels
bug Something isn't working
Projects
None yet
Milestone
v3.0.0
Development

Successfully merging a pull request may close this issue.

*: fix user create issue zhl003/radondb-mysql-kubernetes
3 participants
@acekingke @zhl003 @Littlehhao