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.

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

[bug] The root account of 127.0.0.1 needs to log in without password. #257

Closed
runkecheng opened this issue Oct 11, 2021 · 1 comment · Fixed by #268
Closed

[bug] The root account of 127.0.0.1 needs to log in without password. #257

runkecheng opened this issue Oct 11, 2021 · 1 comment · Fixed by #268
Assignees
Labels
enhancement New feature or request
Milestone

Comments

@runkecheng
Copy link
Collaborator

runkecheng commented Oct 11, 2021

Is your feature request related to a problem? Please describe.

The root account of localhost and 127.0.0.1 needs to log in without password. but the default root password set by yaml is for all root accounts.

Describe the solution you'd like

  • Keep the root account 127.0.0.1 and localhost password synchronized.
  • Support the use of passwords for backup.
  • Set the password of the root account % to a fixed value (only for operator use, no need for users to modify).

Describe alternatives you've considered

Additional context

@runkecheng runkecheng added the enhancement New feature or request label Oct 11, 2021
@runkecheng runkecheng added this to the Next milestone Oct 11, 2021
@runkecheng runkecheng self-assigned this Oct 11, 2021
@runkecheng runkecheng changed the title [bug] The root account of localhost needs to log in without password. [bug] The root account of 127.0.0.1 needs to log in without password. Oct 18, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 18, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 18, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 18, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 18, 2021
@runkecheng
Copy link
Collaborator Author

runkecheng commented Oct 18, 2021

When the password of the root account localhost is inconsistent with the 127.0.0.1 password and when the localhost password is not empty, mysql cannot connect to xenon.

## mysql log
2021/10/15 08:30:52.463249 mysql.go:95: [ERROR] mysql[localhost:3306].ping.error[db.query.timeout[10000, SHOW SLAVE STATUS]].downs:203,downslimits:3
2021/10/15 08:30:52.463318 mysql.go:97: [ERROR] mysql.dead.downs:203,downslimits:3
## xenon log
2021-10-15T08:25:22.441780-00:00 392 [Note] Access denied for user 'root'@'127.0.0.1' (using password: YES)

The host and password in the xenon configuration are set correctly.

bash-5.1$ cat xenon.json 
{
 ...
    "mysql": {
        "admit-defeat-ping-count": 3,
        "admin": "root",
        "ping-timeout": 2000,
        "passwd": "RadonDB@666",
        "host": "localhost",
...
        "port": 3306,
        "monitor-disabled": true
    },
...
}

runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 19, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 19, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 19, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 19, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 19, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 19, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 19, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 20, 2021
runkecheng added a commit to runkecheng/radondb-mysql-kubernetes that referenced this issue Oct 20, 2021
andyli029 added a commit that referenced this issue Oct 21, 2021
*: Fix the problem of password conflict between backup and user management of root user. #257
zhl003 pushed a commit to zhl003/radondb-mysql-kubernetes that referenced this issue Aug 17, 2022
zhl003 pushed a commit to zhl003/radondb-mysql-kubernetes that referenced this issue Aug 17, 2022
zhl003 pushed a commit to zhl003/radondb-mysql-kubernetes that referenced this issue Aug 17, 2022
*: Fix the problem of password conflict between backup and user management of root user. radondb#257
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
1 participant