MySQL Bugs: #108018: innodb and replicaset replication accounts passwords may expire

Bug #108018	innodb and replicaset replication accounts passwords may expire
Submitted:	28 Jul 2022 20:03	Modified:	1 Aug 2022 18:58
Reporter:	Rick Gibson	Email Updates:
Status:	Verified	Impact on me:	None
Category:	Shell AdminAPI InnoDB Cluster / ReplicaSet	Severity:	S4 (Feature request)
Version:	8.0.28	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
After creating a ReplicaSet or InnoDB cluster, the replication account passwords that are automatically created will expire if default_password_lifetime is set. Once the default_password_lifetime period has passed since the instance was added, replication will stop working.

How to repeat:
1. create replica set.
2. set persist default_password_lifetime=x (where x>0)
3. allow x days to pass

Suggested fix:
Suggest using PASSWORD EXPIRE NEVER when creating the replication accounts, or at least having it available as an option when adding new instances.

Alternately have something like rs.updatePasswords() that can manually be run or scripted.

Hi,

This is not a bug. I will log this as Feature Request so the team can take this idea of yours under advisement.

Thanks