| Bug #107696 | MySQL innoDB cluster user account with host IP | ||
|---|---|---|---|
| Submitted: | 29 Jun 2022 5:41 | Modified: | 29 Jun 2022 13:05 |
| Reporter: | Shams ur Rahman Saeed | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | Shell AdminAPI InnoDB Cluster / ReplicaSet | Severity: | S3 (Non-critical) |
| Version: | 8.29 | OS: | CentOS |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | InnoDB Cluster, password update, user account | ||
[29 Jun 2022 13:05]
MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. For details on getting support for MySQL products see http://www.mysql.com/support/ You can also check our forums (free) at http://forums.mysql.com/ Thank you for your interest in MySQL.
Description: I have deployed a MySQL innodb cluster with 3 db servers, after successful deployment I wanted to change the password of a user account 'user'@'20.20.20.%', the operation was successful in the primary server, I flushed the privileges in all servers, now other servers (Secondary) are denying log in to this account from their local host, however the credentials work for these serves as well form mysql shell, and other remote mysql clients. I performed the same operation for another user the user host was ('%') it worked perfect as I was able to use the user and its credential for log in in remote and local. All the servers are withing the same IP range. How to repeat: updating password or creating a new user account in innodb cluster with a host specific IP range, prevents the account to log in secondary servers from local host, however the servers allows the user to be connected from a remote client, or mysqlshell